Re: A free sql analysis tool

At 10:39 8-1-04 -0800, you wrote:
>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: hanksdc_at_about-inc.com
>
>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: ListGuru_at_fatcity.com (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: cjpengel.dbalert_at_xs4all.nl

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: ListGuru_at_fatcity.com (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).