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