| Property | Description |
|---|---|
| Parameter type | String |
| Syntax | CONTROL_MANAGEMENT_PACK_ACCESS = { NONE | DIAGNOSTIC | DIAGNOSTIC+TUNING } |
| Default value | DIAGNOSTIC+TUNING |
| Modifiable | ALTER SYSTEM |
| Basic | No |
CONTROL_MANAGEMENT_PACK_ACCESS specifies which of the Server Manageability Packs should be active. The following packs are available:
The DIAGNOSTIC pack includes AWR, ADDM, and so on.
The TUNING pack includes SQL Tuning Advisor, SQLAccess Advisor, and so on.
A license for DIAGNOSTIC is required for enabling the TUNING pack.
Values:
NONE
Both packs are not available.
DIAGNOSTIC
Only the DIAGNOSTIC pack is available.
DIAGNOSTIC+TUNING
Both packs are available. This is the default.
See Also:
Oracle Database Licensing Information