Plan Stability in Oracle Database 18c Standard Edition

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).

SPM in SE

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

 

 

关注dbDao.com的新浪微博

扫码加入微信Oracle小密圈,了解Oracle最新技术下载分享资源

TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569