Summary of the sessions I attended at #OOW19 gotodba.com/2019/09/26/ora… /cc Brendan Tierney Richard Foote 🇦🇺 Pieter Van Puymbroeck Oracle RAC PM VLDB Bayliss Mike Dietrich Anil Nair Franck Pachot Frits Hoogland

Resolving performance regressions with #oracle 18c and 19c SQL plan management blogs.oracle.com/optimizer/repa…

The CBO Panel Session for UK Oracle User Group 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/2019/09/13/uko…

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/2019/09/13/uko… Maria Colgan VLDB Bayliss Chris Antognini Kevin Foote will be in the hot seats.

Things I never expected to do #14: Announce the cancellation of an event due to a worldwide pandemic. OK, it's not a pandemic yet & we are determined to reschedule, but #OUG_Ireland is being delayed due to the woes of Covid-19 & concerns for our members & speakers. UK Oracle User Group 1/2

Using lock table stats to make life easier blogs.oracle.com/optimizer/lock…

A quick note on #orcldb hint usage reporting in Oracle Database 19c blogs.oracle.com/optimizer/hint…

Some information on the Automatic SQL Tuning Set blogs.oracle.com/optimizer/the-…

I am going to write a short series of posts on improving cardinality estimates. This is the intro blogs.oracle.com/optimizer/sql-…

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/exte…

Improving cardinality estimates with dynamic statistics blogs.oracle.com/optimizer/card…

Follow Friday - some core Oracle Database Product Managers Yasin Baskan @dohdatabase Markus Michalewicz Maria Colgan Gerald Venzl 🚀 Jenny Tsai-Smith VLDB Bayliss Anil Nair MelliAnnamalai @hiphopengineer1 Chris Saxon Loïc Lefèvre Follow all 12 and I'll follow you back :)

It's Follow Friday, so here are some awesome Oracle Database Product Managers you should be following SQL.ProductManager.Oracle.Databases VLDB Bayliss Yasin Baskan krisrice 🏒🍺📷 Markus Michalewicz Ashish Ray Gerald Venzl 🚀 Jenny Tsai-Smith MelliAnnamalai @hiphopengineer1 Chris Saxon Loïc Lefèvre @dohdatabase

ANNOUNCING #tvdpdays 2022 The hybrid event is scheduled on September 28/29. This year’s speakers are VLDB Bayliss Jonathan Lewis Richard Foote 🇦🇺 Stefan Koehler #ShasankChavan Roger Cornejo Martin Klier Martin Berger 🇺🇦 Dani Schnider and me. Check out the agenda... trivadis.com/en/events/perf…

The new SQL analysis report in Oracle Database 23c Free blogs.oracle.com/optimizer/post…

Automatic SPM is now available in #Oracle #Database #19c RU 19.22 EE blogs.oracle.com/optimizer/post…

A new DBMS_SPM function is now available in #Oracle #Database #19c blogs.oracle.com/optimizer/post…

If you use the optimizer_secure_view_merging DB parameter, check out the change in Oracle Database 23ai blogs.oracle.com/optimizer/post…

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/post… for a new ADB demo.