Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: TRACE ANALYZER

Re: TRACE ANALYZER

From: Charles Schultz <sacrophyte_at_gmail.com>
Date: Tue, 8 Aug 2006 20:10:59 -0500
Message-ID: <7b8774110608081810n2334a7cco8ba23b939ba9629@mail.gmail.com>


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-l
Received on Tue Aug 08 2006 - 20:10:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US