dropping analyze objects from data dictionary

I finally managed to find these :

<QUOTE>

From: Oracle, Ken Robinson 09-Jun-03 18:21 Subject: Re : Do I need to analyze SYS owned tables?

Certainly with 9i, many of the problems related to data dictionary statistics are solved. While we do not officially recommend gathering statistics on the data dictionary (yet), many of the data dictionary views include hints and updated statistics can help.

Regards,
Ken Robinson
Oracle Server EE Analyst
</QUOTE>

<QUOTE>

From: Oracle, Rowena Serna 24-Mar-03 18:01 Subject: Re : Analyzing Statistics for CBO in Oracle 9i R2

Prior to Oracle9i the advice of support was that users should "NOT analyze the data dictionary tables (SYS tables) unless you have a very strong reason to do so". With the desupport of the RBO pending in 10i there will only be a CBO so the dictionary will need to be analyzed. The dictionary can now be analyzed without any problems. Note that whilst DBMS_UTILITY.ANALYZE_SCHEMA can be used against the SYS schema Oracle does not perform any regression tests with these tables analyzed and so it is possible that deadlocks or performance problems may be encountered. Also note that a significant number of large databases run extremely succesfully with an analyzed dictionary. see full article
" Cost Based Optimizer - Common Misconceptions and Issues " Regards,
Rowena Serna
Oracle Corporation
</QUOTE>

And also note 35934.1.

The answer seems to be, yeah go aheaad if you like, but I wouldn't if I was you, not until 10i/10g anyway !

Cheers,
Norman.

(Still running with no stats for SYS anywhere !) Received on Wed Jul 30 2003 - 03:38:18 CDT