Incremental Statistics Collection in Oracle 12.1.0.2 – A True Story

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: Incremental Statistics Collection in Oracle 12.1.0.2 – Upgrade Pitfalls A while back I blogged already about Incremental Statistics collection in Oracle Database 12.1.0.2: Incremental Statistics Collection improved in Oracle 12c 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 after DML occurs…

Incremental Statistics Collection in Oracle 12.1.0.2 – Upgrade Pitfalls

A while back I blogged already about Incremental Statistics collection in Oracle Database 12.1.0.2: Incremental Statistics Collection improved in Oracle 12c 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 after DML occurs on the table?  (Mar 18, 2012) https://blogs.oracle.com/optimizer/entry/incremental_statistics_maintenance_what_statistics  And  you may read on this follow-up blog post about a related real world customer example … Incremental Statistics Collection in Oracle 12.1.0.2 – A True Story Database Upgrade Important to know is the fact that…

Incremental Statistics Collection improved in Oracle 12c

Traveling right now through Asia. It was Beijing for 32 hours, Toyko for 24 hours – and now we are running an internal 2-day workshop with colleagues from Korea, New Zealand, India and some other countries in Seoul. And yesterday I had the pleasure to listen to Tom Kyte to his optimizer talk at the OTN Conference in Tokyo. And I learned a lot – as always when having the chance to listen to Tom, Graham Wood and the other great experts. Oracle Database 11.1 offered a great new feature: Incremental Statistics Collection which helped a lot to make stats collection…