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.

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

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

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

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

ANNOUNCING #tvdpdays 2022

The hybrid event is scheduled on September 28/29. This year’s speakers are @vldbb @JLOracle @richardfoote @OracleSK #ShasankChavan @OracleDBTuning @MartinKlierDBA @martinberx @dani_schnider and me.

Check out the agenda...
trivadis.com/en/events/perf…

It's Follow Friday, so here are some awesome @OracleDatabase Product Managers you should be following
@thatjeffsmith @vldbb @yasinbaskan @krisrice @KnownAsMarkus @ashishray @GeraldVenzl @jtsaismith @AnnamalaiMelli @hiphopengineer1 @ChrisRSaxon @Loic__Lefevre @dohdatabase

Follow Friday - some core @OracleDatabase Product Managers

@yasinbaskan @dohdatabase @KnownAsMarkus @SQLMaria @GeraldVenzl @jtsaismith @vldbb @RACMasterPM @AnnamalaiMelli @hiphopengineer1 @ChrisRSaxon @Loic__Lefevre

Follow all 12 and I'll follow you back :)

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

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…

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

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

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

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

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…

@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/2019/09/13/uko…

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

Summary of the sessions I attended at #OOW19
gotodba.com/2019/09/26/ora…
/cc @brendantierney @richardfoote @vanpupi @OracleRACpm @vldbb @MikeDietrichDE @RACMasterPM @FranckPachot @fritshoogland