RE: SHOULD WE ANALYZE 9.2 SYS tables?

From: Chris Stephens <ChrisStephens_at_Affina.com>
Date: Thu, 29 Jul 2004 15:07:18 -0500
Message-ID: <E07BCCA62696AB40BE1267A7419A281A2B5268@apollo.affina.net>

i fEEL dIZZY. :)

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Paul Drake Sent: Thursday, July 29, 2004 2:51 PM
To: oracle-l_at_freelists.org
Subject: Re: SHOULD WE ANALYZE 9.2 SYS tables?

Wolfson Larry - lwolfs <lawrence.wolfson_at_acxiom.com> wrote:

> I had a question about a problem with 9.2 V$ views
> where a RULE hint helped
> V$LOCK tremendously.

> Someone suggested Analyzing the SYS tables. IS
> everyone doing that now or
> is there considerable reticence? I didn't get a
> much current information
> when I searched the FAQ or Google

> Has anyone experienced a downside?

> Is anyone doing some of the tables but not all?

> Thanks
> Larry Wolfson

i hAD hEARD tHAT iN 10g tHE dICTIONARY iS cOST-bASED aND tHAT tHE sYS sCHEMA sHOULD hAVE sTATISTICS gATHERED fOR iT. dUNNO aBOUT 9.2, nOT cURRENTLY gATHERING sTATS fOR iT.=20

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 Thu Jul 29 2004 - 15:15:45 CDT