Re: RE: Trace Analyzer Scripts

  • From: <ryan.gaffuri@xxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 23 Mar 2004 7:26:22 -0500

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. 
> 
> From: John Kanagaraj <john.kanagaraj@xxxxxxx>
> Date: 2004/03/22 Mon PM 03:16:20 EST
> To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
> Subject: RE: Trace Analyzer Scripts
> 
> Larry,
> 
> One *small* modification that you might want to do: Modify TRCAREPO.sql to
> change the type of larger tables from permanent (default) to GLOBAL
> TEMPORARY. You will find that the data is useless once the TRCANLZR.sql
> report completes, and the loading of it can take space and time. GTTs avoid
> this to a large extent.
> 
> John Kanagaraj <><
> DB Soft Inc
> Phone: 408-970-7002 (W)
> 
> Disappointment is inevitable, but Discouragement is optional! 
> 
> ** The opinions and facts contained in this message are entirely mine and do
> not reflect those of my employer or customers **
> 
> >-----Original Message-----
> >From: oracle-l-bounce@xxxxxxxxxxxxx 
> >[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Larry Elkins
> >Sent: Saturday, March 20, 2004 6:16 AM
> >To: oracle-l@xxxxxxxxxxxxx
> >Subject: Trace Analyzer Scripts
> >
> >
> >Anyone have the scripts for creating / running Trace Analyzer? 
> >I don't have
> >access to Metalink right now and can't find the scripts on any of my
> >machines. If anyone would be so kind as to send them 
> >*directly* to me, I
> >would appreciate it.
> >
> >Regards,
> >
> >Larry G. Elkins
> >elkinsl@xxxxxxxxx
> >214.954.1781
> >
> >----------------------------------------------------------------
> >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
> >-----------------------------------------------------------------
> >
> ----------------------------------------------------------------
> 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
> -----------------------------------------------------------------
> 

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

Other related posts: