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!

best practices for gathering statistics in 10g

567263Oct 17 2007 — edited Oct 18 2007

I would like to get some opinions on what is considered best practice for gathering statistics in 10g. I know that 10g has auto statistics gathering, but that doesn't seem to be very effective as I see some table stats are way out of date.

I have recommended that we have at least a weekly job that generates stats for our schema using DBMS_STATS (DBMS_STATS.gather_schema_stats). Is this the right approach to generate object stats for a schema and keep it up to date? Are index stats included in that using CASCADE?

Is it also necessary to gather system stats? I welcome any thoughts anyone might have. Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 15 2007

Added on Oct 17 2007

#general-database-discussions

9 comments

1,166 views