CONTROL_MANAGEMENT_PACK_ACCESS

CONTROL_MANAGEMENT_PACK_ACCESS specifies which of the Server Manageability Packs should be active.

Property	Description
Parameter type	String
Syntax	CONTROL_MANAGEMENT_PACK_ACCESS = { NONE | DIAGNOSTIC | DIAGNOSTIC+TUNING }
Default value	Enterprise Edition: DIAGNOSTIC+TUNING Oracle AI Database Free: DIAGNOSTIC+TUNING All other editions: NONE
Modifiable	ALTER SYSTEM
Modifiable in a PDB	No
Basic	No

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

  Neither pack is available.

• DIAGNOSTIC

  Only the DIAGNOSTIC pack is available.

• DIAGNOSTIC+TUNING

  Both packs are available.

See Also: Oracle AI Database Licensing Information User Manual