Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How important is gathering statistics on SYS objects?

515430Sep 5 2008 — edited Sep 5 2008

Hi,

How important is gathering statistics on Data dictionary tables and other X$ tables in SYS schema. Is it bad to keep the statistics. Recently our Sr.DBA has deleted all the SYS schema stats telling that it will inversely affect the DB performance. Is it true?

Regards
Satish

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 3 2008

Added on Sep 5 2008

#general-database-discussions

6 comments

640 views