Licensing Oracle Tuning Pack In 12c

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.



Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s