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

From: P. van der Ven <pven_at_iname.com>
Date: Sat, 18 Dec 1999 17:39:00 GMT
Message-ID: <385bc679.259603309@news.giganews.com>

>> 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

>That is exactly it.
>The command is
>
>set time on
>
>Marc G. Parkinson

Not exactly, but almost. Using the 'set time on' command you can see what time the query was started and when it stopped, you must do the (very simple) calculation yourselves.

Regards,
P. van der Ven
---
http://contactpven.da.ru/ Received on Sat Dec 18 1999 - 11:39:00 CST