Re: SHOULD WE ANALYZE 9.2 SYS tables?

From: Paul Drake <discgolfdba_at_yahoo.com>
Date: Thu, 29 Jul 2004 12:50:34 -0700 (PDT)
Message-ID: <20040729195034.76116.qmail@web20422.mail.yahoo.com>

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.

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 - 14:48:47 CDT