How to calculate query execution time ?.

[vr76413]

Hello all...

Oracle 817 on Sun 5.8. We are using a web enabled application, which is timing out on certain queries. I was wondering if we can see which Query is timing out and how much time the DB is taking to return the value back to the Application.

I just want to make sure, its not the DB problem. Is there any table or place i can check to see how much time a particular query has taken to execute ?...

Thanks in advance.

Ron

[nir_s]

Hi Ron,

You should ebable a trace on your sql's by using the TKPROF utility.

Regards,
Nir

[vr76413]

Is this TKPROF utility a third party tool ?....Is there any documents you can point me to ?


Thanks
ron

[nir_s]

TKPROF is an oracle installation built in utility.

You can find info. in the following sources:
1. Oracle8i documentation - Designing and Tuning for Performance.
2. metalink.oracle.com (if you have access)
3. Searching for "TKPROF" in google.com

Regards,
Nir