Init parameterDiagnostics & licensing

CONTROL_MANAGEMENT_PACK_ACCESS

What it controls

Which management packs are enabled: the Diagnostics Pack (AWR, ASH, ADDM) and the Tuning Pack.

Know this before you change it

The default turns both on, and using AWR or ASH then counts as pack usage. Set it to NONE if they aren't licensed. The No extra license filter on the scripts hides pack-only scripts.

Default: DIAGNOSTIC+TUNING

Check and change it

1-- Current value on every instance2SELECT inst_id, name, value, isdefault, ismodified3FROM gv$parameter4WHERE name = 'control_management_pack_access';5 6-- Value stored in the spfile7SELECT sid, value FROM v$spparameter WHERE name = 'control_management_pack_access' AND isspecified = 'TRUE';8 9-- Dynamic: takes effect now and is kept after a restart10ALTER SYSTEM SET control_management_pack_access = 'NONE' SCOPE = BOTH SID = '*';11 12-- Remove it from the spfile to go back to the default at the next restart13ALTER SYSTEM RESET control_management_pack_access SCOPE = SPFILE SID = '*';

Related scripts

• AWR settings and recent snapshotsSnapshot interval and retention, then every snapshot from the last 24 hours. You need the snapshot IDs to run an AWR report.

Open in the parameter referenceOracle's reference

More in Diagnostics & licensing

• DIAGNOSTIC_DESTRoot of the Automatic Diagnostic Repository: alert log, traces and incidents.
• MAX_DUMP_FILE_SIZEThe largest trace file a process may write.