Doh! Nothing like Google telling the world about something you put on your website. :-).
The script on the link given is something I put together after reading through Cary and Jeff's book. It's currently pretty simple, and doesn't (yet) handle recursive calls (patches are welcome :-). But for simpler traces, it does a decent job of letting you know where the time in your trace is going.
I'd appreciate any feedback, bug reports, etc. I'd like to see a robust, featureful open-source 10046 trace analyzer developed. (Competition is a good thing, right Cary? :-).
Maybe TFR, TraceFile Repository, developed by Torben Holm form Miracle AS and free downloadable form their site (http://www.miracleas.dk/tools/MirTFR104.zip) might be a starting point? I've used it succesfully in fighting several 'hit-and-run' performance-disaster recovery situations. It's in PL/SQL, combined with iAS, and gives you browser-access to your trace-data. I like it.
Regards, Carel-Jan
=== If you think education is expensive, try ignorance. (Derek Bok) ===
-- Dan
On Thu, 8 Jan 2004, Hatzistavrou John wrote:
> Dear All, > > > > I have found this Perl script that makes an analysis of 10046 SQL trace > > > > http://brainshed.com/software/ > > > > Kind Regards, > > > > > > Hatzistavrou Yannis > > > >
-- ======================================================================== Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division ======================================================================== -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Regards, Carel-Jan
===
If you think education is expensive, try ignorance. (Derek Bok)
===
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Carel-Jan Engel INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
