Taking TKProf to the next level ... TVD$XTAT...

For the past few weeks I have been using the TriVaDis eXtended Tracefile Analysis Tool as a replacement for TKPROF.

TKPROF is available with all Oracle installations but is has some drawbacks. Early versions of TKPROF do not provide any information about bind variables. It also tends to lose detail because it aggregates data. When performing analysis it is unwise to make inferences about detailed execution based on aggregates. TVD$XTAT provides aggregates but also provides detail on each SQL Statement so you can zero in on the statement of interest.

The tool uses Java and requires minimal configuration to get up and running. You can usually point it to the JRE included with Oracle installations.

The tool is free and you can download the package here:
http://antognini.ch/2009/04/tvdxtat-40-beta-9/

-Dave