How to Disable CONTROL_MANAGEMENT_PACK_ACCESS , AWR

Present value

SQL> show parameter control_management_pack_access

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

control_management_pack_access       string      DIAGNOSTIC+TUNING

SQL>

SQL>

SQL>

SQL> SELECT count(*) FROM V$ACTIVE_SESSION_HISTORY;

  COUNT(*)

----------

      2974

Disable control_management_pack_access

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>

http://www.br8dba.com/control_management_pack_access/