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.
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