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!

Gather Schema Stats , Not gathering stats for all Tables

user6421665Apr 27 2011 — edited Apr 27 2011

Hi

I scheduled Gather Schema Stats for a schema in my database .

The job runs successfully without any errors . However, when i query the last_analyzed from user_tables , it shows previous date for most of the tables and for very few tables the latest date.

I believe Oracle is ignoring the tables/indexes where it feels new statistics are now required ?

Am i correct ?

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on May 25 2011

Added on Apr 27 2011

#general-database-discussions

8 comments

759 views