Trace File Event Timeline
A new version of the AppsDBA Interval Resource
Profiler has been released that 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 following is an example graph:
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.
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.
"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
