A recent thread on oracle-l listed several alternatives to the venerable tkprof tool. All of these alternatives have been around for several years, but they were new to me.

I haven’t used any of them yet, but I’m posting this so that I have them at the ready when needed!

trcanlzr.sql -> a tool available on My Oracle Support (MOS) at Doc ID 224270.1. It’s a souped up version of tkprof, apparently.

SQLTXPLAIN -> On MOS at Doc ID 215187.1. It’s a tool that analyzes one SQL statement at a time.

TVD$XTAT -> http://antognini.ch/top/downloadable-files. Created by a gentleman named Christian Antognini.

OraSRP -> http://www.oracledba.ru/orasrp. Created by a fellow named Egor Starostin.

Method-R profiler -> This is a commercial tool available at http://www.method-r.com/software/profiler from the Method-R company.

Advertisements