Insights into Statistics, Query Optimization and the Oracle Optimizer

Plan Stability in Oracle Database 18c Standard Edition

Nigel Bayliss
Product Manager

Oracle Database 18c Standard Edition includes a new way to control SQL execution plans.

Stored outlines were deprecated in Oracle Database 11g Release 1 and SQL plan management (SPM) was only available in Oracle Database Enterprise Edition. This meant that many DBAs continued to use stored outlines in Standard Edition and they continue to work to this day.

At some point in the future we will begin to remove support for stored outlines so, to avoid leaving a hole in SE, we have made a subset of SQL plan management available in this release from Oracle Database 18c onwards.

The license guide remains the single source of truth, so you should always refer to this for full details, but the idea is to give you functionality that's similar to stored outlines using SQL plan baselines. In SE, you can now store a single SQL plan baseline per SQL statement and you have the option to migrate stored outlines directly to SQL plan baselines.

I've provided some example SPM scripts in Github for Enterprise Edition and Standard Edition. The SE approach is very similar to the EE approach (as outlined in this post).


If you have an questions or feedback regarding these scripts, then let me know by leaving a comment below.



Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.