I'm Nigel Bayliss. I work for Oracle. The opinions expressed here are my own. I'm the Oracle Optimizer PM and my background is doing stuff with very large DBs.
At DOAG I was asked an interesting question about real-time SPM and runaway/terminated SQL.
I didn't know the answer for sure, but I do now. Scroll to the bottom of blogs.oracle.com/optimizer/p… for a new ADB demo.
Here's the first follow-up post as promised. It's on extended statistics and includes links to some utility scripts for you to grab and adapt. blogs.oracle.com/optimizer/e…
The list of questions for the CBO panel at the UKOUG TechFest19 is slowly growing - but there's only a week left before the event starts and we could do with a few more questions: jonathanlewis.wordpress.com/…@SQLMaria@vldbb@ChrisAntognini@foote will be in the hot seats.
The CBO Panel Session for @UKOUG TechFest19 has been moved from Monday to Tuesday at 16:45. I'll be chairing it, with a terrific panel of experts - but we need a few more questions in advance: jonathanlewis.wordpress.com/…