Re: TRACE ANALYZER

Charles,

        I have had success running trcanlzr in 10G (10.1.0.4 on AIX 5.2). 
It does have html output as well, it is in udump with a .html extension. I 
use the same metalink doc you specify, and it works well.

hth,
Mike

Michael Boligan
Bayer Corporate and Business Services LLC DBA
North America Information Systems
PHONE 508 660-4698
FAX 508 660-4300
michael.boligan.b_at_bayer.com EMAIL

"Charles Schultz" <sacrophyte_at_gmail.com> Sent by: oracle-l-bounce_at_freelists.org
08/08/2006 09:06 PM
Please respond to
sacrophyte_at_gmail.com

To
edwin_kodamala_at_yahoo.com
cc
oracle-l_at_freelists.org
Subject
Re: TRACE ANALYZER

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.

-- 
Charles Schultz 




_______________________________________________________________________________________________


The information contained in this e-mail is for the exclusive use of the intended recipient(s) and may be confidential, proprietary, and/or legally privileged.  Inadvertent disclosure of this message does not constitute a waiver of any privilege.  If you receive this message in error, please do not directly or indirectly use, print, copy, forward, or disclose any part of this message.  Please also delete this e-mail and all copies and notify the sender.  Thank you.

For alternate languages please go to http://bayerdisclaimer.bayerweb.com


_______________________________________________________________________________________________


--
http://www.freelists.org/webpage/oracle-l