Alternative to TK Prof in oracle 11g

What is alternative to TK prof (used in oracle 9i) in 10g and 11g?

Questions by ishashi

Showing Answers 1 - 0 of 0 Answers


  • Jan 4th, 2012

Trace Analyzer

Traditionally, tkprof has been the best tracing diagnostics tool available.

That is, until the introduction of Trace Analyzer which is everything tkprof is and more. However, as of version 10.2, the Trace Analyzer utility is still not shipped with the Oracle

DBMS like tkprof.

Adv over TK Prof are;

1 Trace Analyzer separates user recursive and internal recursive calls, unlike tkprof
2 Trace Analyzer provides more detailed wait event information, which can be very useful to those DBAs that prefer wait-based tuning methodologies

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions