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

  • 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