Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: TRACE ANALYZER
I should have mentioned, it is VERY easy to use:
START TRCANLZR.sql UDUMP <name of trace file>
Of course, you can play with the other options, but this should get you started. If memory serves, you have to be in the directory where trace analyzer is "installed".
On 8/8/06, Charles Schultz <sacrophyte_at_gmail.com> wrote:
>
> Note:224270.1 Trace Analyzer TRCANLZR v 2.3 December, 2005 by Carlos
> Sierra
> Interpreting Raw SQL Traces with Binds and/or Waits generated by EVENT
> 10046
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
>
> I have used it from time to time - I stopped using it because it does not
> seem to be compatible with 10g, and I never did any digging to find out if
> it could be easily tweaked (I just gave up). However, it worked quite well
> in 9i. It did a great job of grouping all the binds and relevant wait
> information together. My only major gripe was that it was a bit overwhelming
> for large trace files - I would loved to have seen a html version (and if
> there is one, I still might be interested, maybe....). The package was also
> very self-aware, making it easy to run on a new database even if TRCANLZR
> had not yet been installed (it will install itself). Hmm... that might be a
> bad thing, depending on how you look at it. Anyway, I thought Carlos had
> done a fantastic job with it!
>
> Consider yourself warned - large trace files really do take a long time.
>
>
> On 8/8/06, edwin devadanam < edwin_kodamala_at_yahoo.com> wrote:
> >
> > Hi,
> > I want the information pertaining to trace analyzer.(any
> > document,metalink notes...etc)
> > Those who already implemented this tool can give me suggestion as of
> > how to start using this tool.
> > Any help would be appreciated.
> >
> > Thanks,
> > Edwin
> >
> > ------------------------------
> > Stay in the know. Pulse on the new Yahoo.com. Check it out.<http://us.rd.yahoo.com/evt=42974/*http://www.yahoo.com/preview>
> >
> >
>
>
> --
> Charles Schultz
>
-- Charles Schultz -- http://www.freelists.org/webpage/oracle-lReceived on Tue Aug 08 2006 - 20:10:59 CDT