Re: dropping analyze objects from data dictionary

Norman Dunbar wrote:

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

Thanks. I've been looking for a definitive statement from Oracle on this.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)