DBA Hub

šŸ“‹Steps in this guide1/2

How to Disable CONTROL_MANAGEMENT_PACK_ACCESS

How to Disable CONTROL_MANAGEMENT_PACK_ACCESS 1. Overview 2. Display current value 3. Disbale control_management_pack_access 1. Overview We can disable Oracle 11g ADDM, AWR using control_management_pack_access Parameter we can disable the ADDM in Oracle 11g using control_management_pack_access initialization parameter. The values permitted for this parameter are NONE ā€“ Both below packs are not ava

oracle clusteringintermediate
by OracleDba
14 views
1

Overview

NONE TUNING DIAGNOSTIC+TUNING 2. Display current value

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
We can disable Oracle 11g ADDM, AWR using control_management_pack_access Parameter
we can disable the ADDM in Oracle 11g using control_management_pack_access initialization parameter. 

The values permitted for this parameter are
NONE
ā€“
Both below packs are not available
TUNING
ā€“
Only tuning packs (SQL Tuning advisor, SQLAccess Advisor) are avilable
DIAGNOSTIC+TUNING
ā€“ This enables Diagnostic (AWR, ADDM) and tuning packs to the database.
By default the database will be enabled with DIAGNOSTIC+TUNING as the value for the parameter.

When we disable the parameter by putting value as NONE the V$ACTIVE_SESSION_HISTORY table will be empty and ASH, AWR report will not show any content.
2

Section 2

3. Disable control_management_pack_access Caution: Your use of any information or materials on this website is entirely at your own risk. It is provided for educational purposes only. It has been tested internally, however, we do not guarantee that it will work for you. Ensure that you run it in your test environment before using.

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
SQL>
show parameter control_management_pack_access
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
control_management_pack_access       string      DIAGNOSTIC+TUNING
SQL>


SQL>
SELECT count(*) FROM V$ACTIVE_SESSION_HISTORY;
COUNT(*)
----------
        64
<----

SQL>
ALTER SYSTEM SET control_management_pack_access=NONE;
System altered.

SQL>

SQL> show parameter control_management_pack_access

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
control_management_pack_access       string      NONE
SQL>

SQL>
SELECT count(*) FROM V$ACTIVE_SESSION_HISTORY;
COUNT(*)
----------
0 <-----
SQL>

Comments (0)

Please to add comments

No comments yet. Be the first to comment!