Thanks to the paper Oracle Analysis 101, written by Glenn Fawcett (Sun) I have a new Oracle performance troubleshooting tool on my USB key. It’s called orasrp (Oracle Session Resource Profiler), written by Egor Starostin. Basically it’s an Oracle trace file analyzer/profiler with a nice html based report that supports statement graph among other things. It’s written in D language with binaries available for Windows, Linux and Mac OS X. Supports trace files from Oracle 7.2 – 11g.

You can download orasrp from: http://www.oracledba.ru/orasrp/