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.2 beta released 12 Oct 2011.
- Binary distribution for Windows
- Binary installer for Windows
- Binary distribution for Linux
- Binary distribution for Linux x64
- Binary distribution for Mac OS X 10.6 (version 4.1.1)
Contacts
E-Mail: Egor Starostin <egorst@gmail.com>
Twitter: egorst