Simple Profiler

This utility is available free of charge (but under this Creative Commons License). . It enables you to build a response time profile from an Extended Trace file generated for a single Oracle session. The resulting profile will look something like this

Given properly scoped trace information this utility can be used to quickly troubleshoot poorly performing applications. The application is designed around the YAPP method originally proposed by Anjo Kolk, but popularized by Cary Millsap and Jeff Holt of Hotsos. There are a number of restrictions in this utility, and if these prevent you correctly troubleshooting your applications, hotsos sell a full featured profiler which will overcome these. At the time of writing I believe this to be the only commercial, supported profiler for Oracle based applications.  

The utility is based on the TraceAnalyzer utility available from Metalink and I strongly encourage you to read Metalink Note 224270.1 which contains details of this utility. I'd like to thank Carlos Sierra of Oracle for his kind permission to publish a free utility based on his work. Any errors or inaccuracies should of course be directed at me.

Any utility presents data in a format which the author considers to be useful. Whilst I have endeavoured to provide what I consider useful diagnostic output the raw trace data is stored within the SimpleProfiler repository (in tables prefixed SPRF$) so you can report on the data as you see fit.

Version 0.9 contains a number of enhancements and bug fixes. In particular the following should be noted

• The chart display is now customizable. I have made this change since discovering that the SVG plugin could in fact crash certain browsers, notably Mozilla Firefox. To control which chart displays note the customize link at the foot of the page.
• I have added a preliminary business process repository.
• The correct version of the package body is now shipped, this will compile.

Future developments are listed in the readme, I will be looking especially at completing a help system with the 1.0 release and at improvements to the business process repository and trending.

If you are not the DBA of the system on which you wish to install this you should note that the install grants select on the following tables owned by SYS to the application owner, this will require the approval of your DBA.

audit_actions
dba_directories
dba_extents
dba_ind_columns
dba_indexes
dba_objects
dba_segments
dba_tables
dba_temp_files
dba_users
v_$instance
v_$latchname
v_$parameter

Download

File Description	Download
Readme	Simple_Profiler_Readme.txt
Simple Profiler 0.9	SimpleProfiler0.9.zip