SQL Plan Management

Automatic SQL Plan Management in Oracle Database 19c

Automatic SQL Plan Management in Oracle Database 19cWhen you upgrade to a new database release, there will be changes. Some are obvious, others are not. This one is somewhere in between because it is documented quite well but not very well known yet as far as I see. I’m talking about the Automatic SQL Plan Management in Oracle Database 19c.

What is changing in Oracle 19c?

First of all, I don’t want to rewrite everything Nigel Bayliss wrote in his detailed blog post about Automatic SQL Plan Management in Oracle 19c in April 2019. But the essence is:

  • Automatic SQL Plan Management is enabled by
[ Read more ]

SQL Plan Management – Known Issues in Oracle 12.1.0.2

Our Support colleagues released the patch recommendation note for SQL Plan Management (SPM) for Oracle Database 12.1.0.2.

SPM Note

In the unlikely event you’d like to upgrade to Oracle Database 11.2.0.4 or (very very unlikely hopefully) 11.2.0.3 please see these matching notes:

Some additional things to mention:

  • SPM is an Oracle Enterprise Edition feature at no
[ Read more ]