RE: Trace Analyzer Scripts

From: John Kanagaraj <john.kanagaraj_at_hds.com>
Date: Mon, 22 Mar 2004 12:16:20 -0800
Message-ID: <35CFD500D7BDCE43B9030BBA5979DC181D9409@ussccem13.hds.com>

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

Received on Mon Mar 22 2004 - 14:21:02 CST