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