X

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 at the time of writing, 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. 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 and you are making used of this feature, then SQL plan management will make use of it too without further license requirements.

SQL plan management can use SQL tuning sets too. SQL tuning sets are available for use in Oracle Enterprise Edition and can be used by SPM without further license requirements.

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.