CONTROL_MANAGEMENT_PACK_ACCESS specifies which of the Server Manageability Packs should be active. The following packs are available:
DIAGNOSTIC pack includes AWR, ADDM, and so on.
TUNING pack includes SQL Tuning Advisor, SQLAccess Advisor, and so on.
A license for
DIAGNOSTIC is required for enabling the
Both packs are not available.
DIAGNOSTIC pack is available.
Both packs are available. This is the default.
See Also:Oracle Database Licensing Information