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!

Global Stats not being collected using Incremental Stats

user109389Sep 27 2012 — edited Sep 28 2012

I seem to be experiencing a bug with Oracle 11gR2 (11.2.0.2) with collecting global stats when the preference for INCREMENTAL stats is set to TRUE for a partitioned table.

The problem seems to only involve tables that were upgraded from 10.2.0.4 and NOT tables that are created once on 11g itself. The STALE_STATS flag for the overall table (global component) does not seem to be getting set to YES even though the threshold for staleness has been reached and several partitions themselves are flagged as stale. A similar test with a table that was actually built in 11g and NOT upgraded from 10g, does indeed set the flag to YES for the table & relevant partitions and consequently, global stats are obtained.

Has anyone else experienced this issue?

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 26 2012

Added on Sep 27 2012

#general-database-discussions

5 comments

1,045 views