CONTROL_MANAGEMENT_PACK_ACCESS

Property	Description
Parameter type	String
Syntax	`CONTROL_MANAGEMENT_PACK_ACCESS = { NONE \| DIAGNOSTIC \| DIAGNOSTIC+TUNING }`
Default value	Enterprise Edition: `DIAGNOSTIC+TUNING` All other editions: `NONE`
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: