Oracle Session Resource Profiler

What is OraSRP?

OraSRP is a profiler which processes Extended SQL Trace (a.k.a. 10046 event) files and creates session resource profile.

Features

Builds complete and detailed session profile (which includes such pseudo-events like 'PARSE/EXEC/FETCH calls' and 'unaccounted-for time').
Display results either in html or text format.
Display graph of statements calls.
Display events histograms.
Display various session statistics like 'blocks read', 'datafiles read', 'parallel execution' etc.
Group similar statements' statistics into one.
Display values of bind variables.
Parse trace files from Oracle version 7.2 upto 11g.
Written in D programming language and available in binaries for Windows/Linux/Mac OS X.

Samples

Sample One (excessive parsing; demonstration of grouping similar statements' statistics)
Sample Two (slow delete because of row lock contention)
Sample Three (text output; display values of bind variables)

Downloads

Current version is 4.1.3 beta released 24 Nov 2011.

Contacts

E-Mail: Egor Starostin <egorst@gmail.com>
Twitter: egorst