| TKRPOF [message #237925] |
Wed, 16 May 2007 02:40  |
rsreddy28
Messages: 295
Registered: May 2007
|
Senior Member |
|
|
Hello,
Can somebody help in explaining the total difference between TKPROF, STATSPACK and Explain Plan.
I was asked which is better TKRPOF or Explain Plan.
bYe,
Raja
|
|
|
|
|
|
| Re: TKRPOF [message #242411 is a reply to message #237925] |
Fri, 01 June 2007 17:16  |
Thagor
Messages: 9
Registered: April 2007
|
Junior Member |
|
|
Raja,
Statspack is the name for an Oracle product which consists of a schema with its tables, triggers and packages etc. to collect performance statistic of a database (like Oracle Text or Spatial (you have to pay extra for it!)).
If you want to know more about Statspack in general have a look here: http://orafaq.com/faq/what_is_statspack_and_how_does_one_use_it.
And in addition to Frank's reply:
TKprof is a tool (included) to translate/transform (session)trace-files into human-readable form which gives you information about the timings of parses, fetches and executions of (recursive) sql-statements of a session (not the performance of the database as whole).
Greetings,
Thagor
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
