| TKPROF [message #65099] |
Thu, 29 April 2004 03:10  |
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  |
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 |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
