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_at_hds.com>
> Date: 2004/03/22 Mon PM 03:16:20 EST
> To: "'oracle-l_at_freelists.org'" <oracle-l_at_freelists.org>
> 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_at_freelists.org
> >[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Larry Elkins
> >Sent: Saturday, March 20, 2004 6:16 AM
> >To: oracle-l_at_freelists.org
> >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_at_flash.net
> >214.954.1781
> >
> >----------------------------------------------------------------
> >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
> -----------------------------------------------------------------
>
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:23:49 CST
