RE: RE: Trace Analyzer Scripts

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Tue, 23 Mar 2004 07:50:46 -0500
Message-ID: <A186CBDC8B1D61438BC50F1A77E91F73057C1BA3@xchgbrsm1.corp.espn.pvt>

Ryan,

Respectfully I disagree ... it gives much more useful information than tkprof alone... IMHO. On many occasions I have found 'trace analyzer' to be more useful than tkprof. Now, only if I could make that thing go faster .... I haven't tried it in 10g yet, but I use it on a regular basis in 9i.

John:
GTT is a good idea, but you must remember that one *must* finish all analysis in the current session. i.e. once you do initial analysis, if you want to do specific cursor level analysis, do it in the same sqlplus session. If you forget and exit, you have lost the data and you have to start all over again.

Raj

Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. select standard_disclaimer from company_requirements; QOTD: Any clod can have facts, having an opinion is an art !

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of ryan.gaffuri_at_cox.net Sent: Tuesday, March 23, 2004 7:26 AM
To: oracle-l_at_freelists.org
Subject: Re: RE: Trace Analyzer Scripts

I'm not sure trace analyzer gives you much in 9i or 10g since you get the wait events in your trace file anyway. It seems to give you alot of information you really don't need.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

Received on Tue Mar 23 2004 - 06:48:14 CST