Re: analyzing the system tablespace?

In article <8plsl3$3sv$1_at_nnrp1.deja.com>,   kal121_at_my-deja.com wrote:
> Does anyone out there analyze the tables in the system tablespace on a
> regular basis? Seems to me if you are using the CBO, you might as well
> analyze everything. And yet, I hold back.
>
> Any thoughts?
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Holding back is the wisest choice. One should NEVER collect statistics on the data dictionary tables (SYSTEM tablespace). The data dictionary is designed to function optimally in the absence of statistics. Don't attempt to "improve" things in the SYSTEM tablespace with ANALYZE.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com http://www.deja.com/
Before you buy.