Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> 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. 1216Received on Thu Nov 11 2004 - 22:56:49 CST
> -----Original Message-----
> From: Rick Stephenson [mailto:RStephenson_at_Ovid.com]
> Sent: Thursday, November 11, 2004 1:50 PM
> To: oracle-l_at_freelists.org
> 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