RE: SHOULD WE ANALYZE 9.2 SYS tables?
- From: "Chris Stephens" <ChrisStephens@xxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 29 Jul 2004 15:07:18 -0500
i fEEL dIZZY. :)
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Paul Drake
Sent: Thursday, July 29, 2004 2:51 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: SHOULD WE ANALYZE 9.2 SYS tables?
--- Wolfson Larry - lwolfs
<lawrence.wolfson@xxxxxxxxxx> 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
pD
----------------------------------------------------------------
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:
