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

NAME

Oracle::Trace - Perl Module for parsing Oracle Trace files

SYNOPSIS

use Oracle::Trace;

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

DESCRIPTION

Module for parsing and describing an Oracle Trace file.

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.

EXPORT

None by default.

SEE ALSO

http://www.rfi.net/oracle/trace/

AUTHOR

Richard Foley, <oracle.trace@rfi.net>

COPYRIGHT AND LICENSE

Copyright (C) 2003 by Richard Foley

This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself, either Perl version 5.8.1 or, at your option, any later version of Perl 5 you may have available.