Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Nov 29th, 2011

 

You can make use of PL/SQL based TRCA

Other notable alternatives are
SQLTXPLAIN
Method-R profiler
OraSRP
TVD$XTAT

geekano

 Profile Answers by geekano 

• 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