Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Timing Tests for SQL stmts
SQL> SET TIMING ON
SQL> SET TERMOUT OFF
(depending on you o/s will depend on what you see...)
Nancy.Thalman_at_lasp.colorado.edu wrote in message
<881688114.25764_at_dejanews.com>...
>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