Recently I came across a really interesting customer case in the UK dealing with Incremental Statistics Collection issues in regards to an upgrade to Oracle Database 12.1.0.2.
This is the follow-up blog post to:
A while back I blogged already about Incremental Statistics collection in Oracle Database 12.1.0.2:
And you’ll find more information in our documentation and in posts by our optimizer folks:
- Database SQL Tuning Guide 12c:
Gathering Incremental Statistics on Partitioned Objects - Incremental Statistics Maintenance – what statistics will be gathered