Oracle Instrumentation
Check out the AppsDBA paper Oracle Instrumentation.
This is the original version. An edited version appeared in the IOUG SELECT Journal in the first quarter
of 2009.

Trace File Event Timeline

The AppsDBA Interval Resource Profiler now includes the ability to create a trace file event timeline. The technique is described in more detail in blog posts starting here. This is a new technique that creates a graph of the events in a trace file grouped in approximately equal intervals. The advantage of this technique is to allow the visualization of event skew within a trace file. This may help illustrate scoping problems or event skew that might otherwise be hidden by the profile summary.
The new utility is a perl script called resource_event.pl. It requires the perl GD module, but a CSV file can also be created that can be imported into Excel for more sophisticated graphing.

Trace File Execution Tree
A new utility to parse an extended SQL trace file and create an an indented listing of PARSE, EXEC and FETCH statements with recursive and exclusive times summarized for each depth. This is the utility mentioned in

this blog entry and makes it much easier to follow the time accounting when trying to reconcile recursive and exclusive time in the trace file.

"Conventional wisdom is opinion that has been repeated enough over time to become accepted as fact. While sometimes it can be fact, most times it is not." - Tom House, The Picture Perfect Pitcher, 2003
|