Insights into Statistics, Query Optimization and the Oracle Optimizer
-
SQL Plan Management
January 16, 2020
Does the use of SQL Plan Management and the DBMS_SPM database package require a tuning or diagnostic pack license?
Always check your license guide for up-to-date information on your specific database version, but you will see that SPM is available as part of Oracle Database Enterprise Edition and, in addition, a subset of SPM functionality is available in Oracle Database Standard Edition from Oracle Database 18c onwards.
If you have a licence to use AWR, then SQL plan management can be used in conjunction with this repository without additional licenses.
SQL plan management can interact with SQL tuning sets, which are included in Oracle Database Enterprise Edition. SPM can therefore be used in conjunction with SQL tuning sets without additional licenses.
Join the discussion
Comments ( 4 )
Thanks for the reminder about SPM
Recently during the Open World conference a lot of people asked me about what additional licenses are need to use SQL Plan Management. No additional licenses are needed to use SQL Plan Management (SPM) or any of the procedures in the DBMS_SPM package. SPM is available as part of Oracle Database Enterprise Edition 11g.
Customer Question (Bundesministerium der Finanzen)
Does the above also apply for Oracle database version 12c?
Thank you
https://blogs.oracle.com/optimizer/plan-stability-in-oracle-database-18c-standard-edition