Home » RDBMS Server » Server Utilities » TKRPOF
TKRPOF [message #237925] Wed, 16 May 2007 02:40 Go to next message
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 #237958 is a reply to message #237925] Wed, 16 May 2007 03:40 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
TKProf output will include an explain plan (explain= option) with some extra info. See:

http://www.orafaq.com/wiki/TKProf
http://www.orafaq.com/wiki/Explain_Plan
Re: TKRPOF [message #242411 is a reply to message #237925] Fri, 01 June 2007 17:16 Go to previous message
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
Previous Topic: exporting procedure-in user mode
Next Topic: how to load fix length formatted data from a file
Goto Forum:
  


Current Time: Sun Dec 04 10:49:29 CST 2016

Total time taken to generate the page: 0.10924 seconds