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

Even better, from Oracle PL/SQL Programming by Steve Feuerstein is this:

P. van der Ven wrote in message <385bc679.259603309_at_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/

begin 666 mesaure_time.sql
M1$5#3$%210T*=&EM95]B969O<F4_at_8FEN87)Y7VEN=&5G97([#0IT:6UE7V%F M=&5R(&)I;F%R>5]I;G1E9V5R.PT*0D5'24X-"G1I;65?8F5F;W)E(#H]($1" M35-?551)3$E462Y'151?5$E-13L-"F-A;&Q?=&AE7W!R;V-E9'5R95]O<B!S M<6P@<W1A=&5M96YT(&AE<F4[#0IT:6UE7V%F=&5R(#H]($1"35-?551)3$E4 M62Y'151?5$E-13L-"D1"35-?3U544%54+D5.04),13L-"D1"35-?3U544%54 M+E!55%],24Y%*"=4;W1A;"!4:6UE('1A:V5N(&ES("<@?'P@*'1I;65?869T M97(@+2!T:6UE7V)E9F]R92D-"B @(" @(" @(" @(" @(" @(" @('Q\("<@ @,3 P=&AS(&]F(&$@<V5C;VYD)RD[#0I%3D0[#0HO#0H` `
end Received on Mon Dec 20 1999 - 05:26:13 CST