Automatic SQL Plan Management in Oracle Database 19c

When 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 default in…

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. MOS Note:2035898.1 Patches to Consider for 12.1.0.2 to Avoid Problems with SQL Plan Management (SPM) 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: MOS Note:2034706.1 Patches to Consider for 11.2.0.4 to Avoid Problems with SQL Plan Management (SPM)) MOS Note:1948958.1 Patches to Consider for 11.2.0.3 to Avoid Problems with SQL Plan Management (SPM) Some additional things to mention: SPM is an Oracle Enterprise Edition feature at no extra…