Insights into Statistics, Query Optimization and the Oracle Optimizer

Does the use of SQL Plan Management and the DBMS_SPM database package require a tuning or diagnostic pack license?

Nigel Bayliss
Product Manager

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 )
  • Foued Tuesday, March 1, 2016

    Thanks for the reminder about SPM

  • guest Monday, May 9, 2016

    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

  • Ian Lewis Monday, April 1, 2019
    Is SPM an Enterprise Edition only tool? Therefore it cannot be used with Standard Edition (SE, SE1 or SE2)?
  • Nigel Bayliss Monday, April 1, 2019
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.