Wednesday, September 7, 2016

How to disable/remove AWR snapshot genration and ADDM job from oracle database

Disabling Oracle Performance Pack

   Disabling Performance Tuning & Diagnostic pack:

Method 1:  Revoking Management Pack Access through OEM
Home Page>setup>Management Pack Access <Remove Access> <Apply>




Method 2:
  Step 1

Disable Automatic/manual AWR snapshots                    

SQL> @dbmsnoawr.plb  <This Package is downloaded from My Support Article ID 436386.1>

SQL> begin dbms_awr.disable_awr(); end;

Impact:

·         Stops Automatic AWR snapshots
·         Does not allow taking manual snapshot.
·         All  <report>.sql files will work for old snaps

Step 2
To Disable Automatic ADDM
ALTER SYSTEM set "_addm_auto_enable"=false;
(Dynamic parameter)

Impact:
·         Disables automatic ADDM which gets run automatically after every Automatic AWR snapshots
CONTROL_MANAGEMENT_PACK_ACCESS to NONE disables ADDM.

No comments:

Post a Comment