Re: SQL with no output

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Wed, 19 Nov 2003 01:47:07 GMT
Message-ID: <vYzub.12497$nX4.4251@news01.roc.ny>

"Rick Denoire" <100.17706_at_germanynet.de> wrote in message news:jiblrvgip366t7cah6rgrea4620ac80h3l_at_4ax.com...
> I would like to execute some SQL scripts contained in one file, but I
> am actually interested only in the exection time (so I will "set
> timing on" in sqlplus).
>
> How can I avoid getting any output from the scripts other than
> execution time? (Using sqlplus, I mean).
>
> Bye
> Rick Denoire
>

You can
* Use pl/sql to do the timing

   begin
   for x in (the select statement)
   loop

      null;
   end loop;
   /
* Use perl/java ... to do the timing
* set autotrace traceonly statistics

... will have timing overhead of setting autotrace

Different methods have different overheads.

Anurag Received on Tue Nov 18 2003 - 19:47:07 CST