Re: Building a benchmark query

"C. Derrick" schrieb:

> I would like to take a Select query and change it have it return a measure
> of the amount of time the it took to execute rather than the result set.
>
> Does anyone have any suggestions of ways to do this?

this will accumulate the time until 'timing show' or 'timing stop'

SQL> timing start timer

SQL> select 'here it is...' from dual;

SQL> timing show

SQL> timing stop

or just do

SQL> set timing on

this will automatically show the time for each statement.

hope this will help you, let me know,.

Regards, Stephan

--

Dipl.-Inf. (FH) Stephan Born   | beusen Consulting GmbH
fon: +49 30 549932-17          | Landsberger Allee 392
fax: +49 30 549932-29          | 12681 Berlin
mailto:stephan.born_at_beusen.de  | Germany
---------------------------------------------------------------
                       PGP-Key available
---------------------------------------------------------------