Home » RDBMS Server » Server Utilities » TKRPOF
TKRPOF [message #237925] Wed, 16 May 2007 02:40 Go to next message
Messages: 295
Registered: May 2007
Senior Member

Can somebody help in explaining the total difference between TKPROF, STATSPACK and Explain Plan.

I was asked which is better TKRPOF or Explain Plan.


Re: TKRPOF [message #237958 is a reply to message #237925] Wed, 16 May 2007 03:40 Go to previous messageGo to next message
Frank Naude
Messages: 4509
Registered: April 1998
Senior Member
TKProf output will include an explain plan (explain= option) with some extra info. See:

Re: TKRPOF [message #242411 is a reply to message #237925] Fri, 01 June 2007 17:16 Go to previous message
Messages: 9
Registered: April 2007
Junior Member

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).

Previous Topic: exporting procedure-in user mode
Next Topic: how to load fix length formatted data from a file
Goto Forum:

Current Time: Tue Jul 25 06:01:19 CDT 2017

Total time taken to generate the page: 0.07894 seconds