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: RE: Trace Analyzer Scripts

RE: RE: Trace Analyzer Scripts

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Tue, 23 Mar 2004 08:51:23 -0500
Message-ID: <A186CBDC8B1D61438BC50F1A77E91F73057C1BA5@xchgbrsm1.corp.espn.pvt>


No idea ... haven't yet started playing with 10g at that level.

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 Niall Litchfield Sent: Tuesday, March 23, 2004 8:43 AM
To: oracle-l_at_freelists.org
Subject: RE: RE: Trace Analyzer Scripts

Isn't trace analyze at the very least deprecated in 10?

> -----Original Message-----
> From: Rajendra.Jamadagni_at_espn.com
> Sent: 23 March 2004 12:50
> To: oracle-l_at_freelists.org; Rajendra.Jamadagni_at_espn.com
> 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_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
> -----------------------------------------------------------------
>
>



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_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
-----------------------------------------------------------------
----------------------------------------------------------------
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 - 07:50:47 CST

Original text of this message

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