Home » RDBMS Server » Performance Tuning » TKPROF
TKPROF [message #65099] Thu, 29 April 2004 03:10 Go to next message
Monu
Messages: 5
Registered: April 2004
Junior Member
I have collected statistics for some stored peocedures using tkprof .i made use of some optimizer hints aswell.. and without hints

so can you tell me how to interpret the output of tkprof.

ie is a loww value of cpu,elapsed etc are better than a higher value.

thanks

Gaurav
Re: TKPROF [message #65100 is a reply to message #65099] Thu, 29 April 2004 03:58 Go to previous messageGo to next message
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
Senior Member
Hi,

First of all let us know wht types of issues u want to address.

Well in tkprof u should give high consideration on PHYSICAL READS, PARSE HIT RATIO & DB CACHE HIT RATIO.
This info will give you the status of ur shared and buffer pools.

There are 22 different options availble to sort the output of TKPROF. you can use that according to ur requirement.

Apart from ur TKPROF u can use various V$ views to address some specific issues like block contention etc.

For more info refer oracle doc.

Daljit Singh.
Re: TKPROF Continue. [message #65101 is a reply to message #65100] Thu, 29 April 2004 04:03 Go to previous message
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
Senior Member
Sorry, i forgot to include one important aspect that is WAITS.

Using TKPROF u can check whether ur procedure is waiting for any resource or not, if yes, so for how much time?

Be sure that the parameter TIMED_STATISTICS is true in ur environment to take full advantage of TKPROF.

Daljit Singh.
Previous Topic: Using Index Monitoring in Oracle 9i
Next Topic: foreign keys affect performance?
Goto Forum:
  


Current Time: Wed Sep 23 13:19:46 CDT 2020