Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Timing Tests for SQL stmts

Timing Tests for SQL stmts

From: <Nancy.Thalman_at_lasp.colorado.edu>
Date: 1997/12/09
Message-ID: <881688114.25764@dejanews.com>#1/1

Hi,

I'm using a demo version of Oracle 8.0.3 on a Solaris and I want to perform timing tests in SQL Plus on some select stmts.

Are there timing cmds that I can use in SQL Plus to determine elapsed time for the execution of a select stmt and is there a way to turn off screen I/O in SQL Plus while the select stmt is executing?

Any assistance would be greatly appreciated.

Thanks,

Nancy Thalman

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet
Received on Tue Dec 09 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US