Registration for MOTS is now open. If you fancy a couple of days intense learning from some of the best Oracle minds, or simply some chat about Cuddly Toys over a few beers prior to going to Oracle Openworld, sign up now for a mere $450. I talked about it more here.
Updated later - Title fixed - Miracle on the brain! Thanks, Koert.
MOTS - "Modifiable or Modified off-the-shelf Software is a COTS product whose source code can be modified or customized, by the purchaser or vendor for specific applications to meet customer requirements. "
Since that's been a big chunk of my career for the last 30 years I had to say something.
Part 1 - Default options - GLOBAL AND PARTITION Part 2 - Estimated Global Stats Part 3 - Stats Aggregation Problems I Part 4 - Stats Aggregation Problems II Part 5 - Minimal Stats Aggregation Part 6a - COPY_TABLE_STATS - Intro Part 6b - COPY_TABLE_STATS - Mistakes Part 6c - COPY_TABLE_STATS - Bugs and Patches Part 6d - COPY_TABLE_STATS - A Light-bulb Moment Part 6e - COPY_TABLE_STATS - Bug 10268597
A couple of posts about Incremental Stats confusion
For the avoidance of any doubt, all views expressed here are my own and not those of past or current employers, clients, friends, Oracle Corporation, my Mum or, indeed, Flatcat. If you want to sue someone, I suggest you pick on Tigger, but I hope you have a good lawyer. Frankly, I doubt any of the former agree with my views or would want to be associated with them in any way.