Return-Path: <oracle-l-bounce@freelists.org>
Delivered-To: 2-oracle-l@orafaq.com
Received: (qmail 6182 invoked from network); 8 Aug 2006 20:12:36 -0500
Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180)
  by 69.64.49.119 with SMTP; 8 Aug 2006 20:12:09 -0500
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 504EE3BDCCA;
 Tue,  8 Aug 2006 21:11:37 -0400 (EDT)
Received: from turing.freelists.org ([127.0.0.1])
 by localhost (turing [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id 31318-05; Tue, 8 Aug 2006 21:11:37 -0400 (EDT)
Received: from turing (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 306B53BEB5E;
 Tue,  8 Aug 2006 21:11:35 -0400 (EDT)
Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 08 Aug 2006 21:10:44 -0400 (EDT)
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7CCD13BEB07
 for <oracle-l@freelists.org>; Tue,  8 Aug 2006 21:10:44 -0400 (EDT)
Received: from turing.freelists.org ([127.0.0.1])
 by localhost (turing [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id 30615-07 for <oracle-l@freelists.org>;
 Tue, 8 Aug 2006 21:10:44 -0400 (EDT)
Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.180])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0F4DC3BEB06
 for <oracle-l@freelists.org>; Tue,  8 Aug 2006 21:10:44 -0400 (EDT)
Received: by py-out-1112.google.com with SMTP id z74so108116pyg
        for <oracle-l@freelists.org>; Tue, 08 Aug 2006 18:10:59 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
        b=GXVpr7vwOYnURxbpBGllUqmPn1xsCNEyULXecNr+veKfKq5qcd/ubvLmpV9GXI7fBrhA0B+nGzct0SdkALI+aCub8QqD/tQL+k7rj124tGpMed1radxm5W7FgiP6cYAjH58U9LSfk1xjQHfVle5BZkJYNYZW0Pf9B/bnqrvjf4c=
Received: by 10.35.77.1 with SMTP id e1mr418689pyl;
        Tue, 08 Aug 2006 18:10:59 -0700 (PDT)
Received: by 10.35.53.13 with HTTP; Tue, 8 Aug 2006 18:10:59 -0700 (PDT)
Message-ID: <7b8774110608081810n2334a7cco8ba23b939ba9629@mail.gmail.com>
Date: Tue, 8 Aug 2006 20:10:59 -0500
From: "Charles Schultz" <sacrophyte@gmail.com>
To: edwin_kodamala@yahoo.com
Subject: Re: TRACE ANALYZER
Cc: oracle-l@freelists.org
In-Reply-To: <7b8774110608081806o1c5c9bkde76847add9080f2@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_Part_92688_19929356.1155085859514"
References: <20060808213755.57871.qmail@web52301.mail.yahoo.com>
	 <7b8774110608081806o1c5c9bkde76847add9080f2@mail.gmail.com>
X-archive-position: 37915
X-ecartis-version: Ecartis v1.0.0
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
X-original-sender: sacrophyte@gmail.com
Precedence: normal
Reply-to: sacrophyte@gmail.com
X-list: oracle-l
X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at avenirtech.net
------=_Part_92688_19929356.1155085859514
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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@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@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

------=_Part_92688_19929356.1155085859514
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

I should have mentioned, it is VERY easy to use:<br><span style="font-family: courier new,monospace;">START TRCANLZR.sql UDUMP &lt;name of trace file&gt;</span><br><br>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 &quot;installed&quot;.
<br><br><div><span class="gmail_quote">On 8/8/06, <b class="gmail_sendername">Charles Schultz</b> &lt;<a href="mailto:sacrophyte@gmail.com">sacrophyte@gmail.com</a>&gt; wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>Note:224270.1 Trace Analyzer TRCANLZR v 2.3 December, 2005 by Carlos Sierra<br>Interpreting Raw SQL Traces with Binds and/or Waits generated by EVENT 10046<br>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
<br><br>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!
<br><br>Consider yourself warned - large trace files really do take a long time.</div><div><span class="e" id="q_10cf07763aa12690_1"><br><br><div><span class="gmail_quote">On 8/8/06, <b class="gmail_sendername">edwin devadanam
</b> &lt;<a href="mailto:edwin_kodamala@yahoo.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
edwin_kodamala@yahoo.com</a>&gt; wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div>Hi,<br>&nbsp;I want the information pertaining to trace analyzer.(any document,metalink notes...etc)
<br>&nbsp; Those who already implemented this tool can give me suggestion as of how to start using&nbsp;this tool.<br>&nbsp;&nbsp; Any help would be appreciated.<br>&nbsp;<br>Thanks,<br></div><div><span>Edwin<br></span></div><div><span>
<p> 
		</p><hr size="1">Stay in the know. Pulse on the new <a href="http://Yahoo.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">Yahoo.com</a>. <a href="http://us.rd.yahoo.com/evt=42974/*http://www.yahoo.com/preview" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">

 Check it out.</a> 

<p></p></span></div></blockquote></div><br><br clear="all"><br></span></div><div>-- <br></div><div><span class="sg">Charles Schultz

</span></div></blockquote></div><br><br clear="all"><br>-- <br>Charles Schultz

------=_Part_92688_19929356.1155085859514--
--
http://www.freelists.org/webpage/oracle-l