Re: Timing Tests for SQL stmts

in sqlplus, set timing on gives you execution and elapsed time set termout off stops screen i/o ...
note that Oracle caching the query and query results to memory could have a drastic impact to your timing tests.

another method would be to use explain plan and set timed_statistics=true
in your init.ora ... caching will still be an issue. Greg

Nancy.Thalman_at_lasp.colorado.edu wrote:

> 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 Wed Dec 10 1997 - 00:00:00 CST