Re: execution time of a query?

Hi,

The best way to find the execution time is to set a session in trace (alter session set sql_trace=true) and use tkprof.

Regards

ashrivastava_at_auriga-insys.com (Anand) wrote in message news:<396cc940.0208280308.76da0267_at_posting.google.com>...
> Hi,
>
> How can I find out the execution time of any query?
> I have little info about "timing start" and "timing stop"; but I have
> certaing doubts as well.
> - Does it give execution time or the time from issuing the "timing
> start" till "timing stop"?
> - The sample result that I got is: 00:01:77.00
> How should I interpret this, is it 1 minute and 77 seconds or 1 second
> and 77 ms or something else?
>
> Regards,
> Anand
Received on Sat Sep 07 2002 - 10:22:43 CEST