Oracle::Trace 1.06

Oracle::Trace is a Perl Module for parsing Oracle Trace files.

SYNOPSIS

use Oracle::Trace;

print Oracle::Trace->new($tracefilename)->parse->test_report;

Currently the parsing and statistics are very rudimentary, and in certain matters may be fundamentally flawed - you have been warned! Expect this to improve as further development takes place.

new

Create a new object for a given Orace Trace file.
my $o_trc = Oracle::Trace->new($tracefile);

init

Initialise the object (check the tracefile).
$o_trc->init.

opentracefile

Perform basic exists/read/etc. checks on given tracefile.
Returns object or undef.
$o_trc = $o_trc->checkfile($tfile);

header

Return the Header object.
my $o_hdr = $o_trc->header;

entries

Return Entry objects which comply with given regex criteria.
my @o_ents = $o_trc->entries('type'=>'EXEC #d+', 'key'=>dep, 'value'=>0);

oids

Return the unique object ids for the currently known Entryies
my @oids = $o_trc->oids;

footer

Return the Footer object
my $o_ftr = $o_trc->footer;

test_report

Return a simple test_report of the current object.
print $o_trc->test_report('string');

mini_report

Return a simple string of descending order timings for the statements retrieved from the given objects.
my $s_str = $o_trc->mini_report($i_max, @o_objs);

Note that we use microsecond resolution for Oracle 9i and above and centisecond resolution otherwise

Requirements:

· Perl



Product's homepage

Requirements:

· Perl