Re: Timing a query in sqlplus

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. Received on Fri Feb 02 2007 - 08:41:56 CST