AppsDBA Resource Profiler

The AppsDBA Resource Profiler is a perl based extended SQL trace interval resource profiler. The resource profiler will parse an Oracle event 10046 level 8 or higher trace file and create an interval resource profile for each session found in the trace file. It will also produce tkprof-like statement totals sections for all recursive and non-recursive statements. This can help in comparisons of accuracy between tkprof and the resource profiler output. In general, you will find that the resource profiler is more accurate than tkprof. The AppsDBA Resource Profiler supports extended SQL trace files from version 7 through 10g Release 2.

Output can be generated in either text format or W3C HTML 4.01 compatible output. It requires perl to run. Additional help is available in pod (plain old documentation) format and can be displayed by running the resource profiler through perldoc (e.g. perldoc resource.pl).

The latest version supports Oracle 10g Release 2 wait event formats in addition to previous release formats.

Utility Source: resource.zip

Example Output:

Resource Profile Text Output

Resource Profile HTML Output