CONTROL_MANAGEMENT_PACK_ACCESS

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.