EscVector wrote:
> On Feb 2, 7:41 am, "astalavista" <nob..._at_nowhere.com> wrote:
>> Hi,
>>
>> In sqlplus, how to time a query ?
>> I set timing on
>> but the result seems to skewed by the display of the output lines (lot of
>> rows), no ?
>> How to get the correct timing for a query ?
>>
>> Thanks in advance
>
> You could run it from a script with no output to screen or run create
> a refcursor and time the block execution.
>
How about set autotrace traceonly statistics and set timing on
You get the timing and other stats also.
Received on Fri Feb 02 2007 - 10:52:11 CST
