Re: timing a sql transaction (bpolarsk demo'd)

That is exactly it.
The command is

set time on

Marc G. Parkinson

ccyr6798_at_my-deja.com wrote:

> In a response to a query yesterday, I saw an example (posted by
> bpolarsk) which returned elapsed time for a sql plus stmt. I've been
> unable to find how to turn this feature on - unless it's part of "set
> timing on". anyone know?
>
> the example was something like
>
> sql> select count (*) from table;
>
> 52000
>
> elapsed time 0:00:08.51
>
> sql>
>
> thanks,
> Cary
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Dec 16 1999 - 19:50:17 CST