On Feb 2, 11:52 am, Oradba Linux <oradba_li..._at_verizon.net> wrote:
> 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.
I've had stats skew the time slightly. Maybe not by much, but I
believe Elapsed is a component of the whole in the sqlplus output.
Received on Fri Feb 02 2007 - 11:07:16 CST
