RE: Query execution time

There is. Record elapsed time programatically using timer_gettime or
Time::HiRes,
then add all those collected times and divide by the number of executions.
Another method is to multiply all the collected values and take the N-th
root
from that product, where the number N is the number of samples. The third
way is 
just to observe the most frequently appearing value.


--
Mladen Gogala
A & E TV Network
Ext. 1216


> -----Original Message-----
> From: Rick Stephenson [mailto:RStephenson@xxxxxxxx] 
> Sent: Thursday, November 11, 2004 1:50 PM
> To: oracle-l@xxxxxxxxxxxxx
> Subject: Query execution time
> 
> 
> I have a query that has been executed 750,000 times and want 
> to know what the maximum elapsed time is for that query. The 
> v$sql view gives me an elapsed_time column, but that will 
> only allow me to produce an average elapsed time based on the 
> number of times a query has been executed.  Is there a way to 
> determine the maximum elapsed time for a query?
--
http://www.freelists.org/webpage/oracle-l

Other related posts: