RE: Query execution time
- From: "Gogala, Mladen" <Mladen.Gogala@xxxxxxxx>
- To: "'RStephenson@xxxxxxxx'" <RStephenson@xxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Thu, 11 Nov 2004 16:39:16 -0500
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?
--
//www.freelists.org/webpage/oracle-l
Other related posts:
