In the Oracle 12c these are the features and services offered by the database and must be licensed to use. This is the list of features that need TUNING License;
- SQL Access Advisor
- SQL Tuning Advisor
- Automatic SQL Tuning
- SQL Tuning Sets
- SQL Profiles
- Real-time SQL and PL/SQL Monitoring
- Real-time Database Operations Monitoring
- Reorganize objects
On the other hand, from the version 11, Oracle includes the parameter in which we indicate the type of license that we currently (control_management_pack_access) to simplify the administration of the system. This parameter can have the following values;
NONE– Neither pack is available.
DIAGNOSTIC– Only the DIAGNOSTIC pack is available.
DIAGNOSTIC+TUNING– Both packs are available. This is the default.
HTH – Antonio NAVARRO