Enabling Oracle Performance Pack


Enabling Performance Tuning & Diagnostic pack:
 
Method 1:  Granting Management Pack Access through OEM

Home Page>setup>Management Pack Access <Grant Access> <Apply>


Method 2:

ü  Step 1

Enable Automatic/manual AWR snapshots                       

SQL> begin dbms_awr.enable_awr(); end;
Impact:
·         Starts Automatic AWR snapshots on Hourly basis
·         Allows taking manual snapshot.
·         All  <report>.sql files will start working after 2 Hrs

ü  Step 2

To Enable Automatic ADDM
ALTER SYSTEM set "_addm_auto_enable"=true;

Impact:
·         Enables automatic ADDM which gets run automatically after every Automatic AWR snapshots

ü  Step 3

Reconfigure dbconsole
Emca -config dbcontrol db -repos create

Impact:
·         Enables complete Management Access Pack along with OEM

Method 3: (Applicable for Oracle 11g)

Set parameter

  • Alter system set CONTROL_MANAGEMENT_PACK_ACCESS=’DIAGNOSTIC+TUNING’;
(default Value)

Impact:
·         Enables Complete Performance & tuning pack

 

1 comment:

My Popular Posts