Isn't trace analyze at the very least deprecated in 10? > -----Original Message----- > From: Rajendra.Jamadagni@xxxxxxxx > Sent: 23 March 2004 12:50 > To: oracle-l@xxxxxxxxxxxxx; Rajendra.Jamadagni@xxxxxxxx > Subject: RE: RE: Trace Analyzer Scripts > > > 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@xxxxxxxxxxxxx > [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of > ryan.gaffuri@xxxxxxx > Sent: Tuesday, March 23, 2004 7:26 AM > To: oracle-l@xxxxxxxxxxxxx > 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@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- > > ********************************************************************** This email contains information intended for the addressee only. It may be confidential and may be the subject of legal and/or professional privilege. Any dissemination, distribution, copyright or use of this communication without prior permission of the sender is strictly prohibited. ********************************************************************** ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------