CONTROL_MANAGEMENT_PACK_ACCESS

 Thank you for visiting Spatial DBA - Oracle and ArcSDE.

Please visit Oracle DBA Tips (http://www.oracledbatips.com) for more Oracle DBA Tips.

====================================================================

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.

Note:
1. This parameter was introduced in 11g.
2. Query for the current value of the parameter

select name, value, isdefault, isses_modifiable, issys_modifiable,

isinstance_modifiable, isdeprecated, description

from v$parameter where upper(name) = ‘CONTROL_MANAGEMENT_PACK_ACCESS’;

Oracle initializatoin parameters