Sunday 29 July 2012

Privileges Required to Generate AWR Report

Below are the Privileges required to generate AWR Report:-

SELECT ON SYS.V_$DATABASE 
SELECT ON SYS.V_$INSTANCE 
EXECUTE ON SYS.DBMS_WORKLOAD_REPOSITORY 
SELECT ON SYS.DBA_HIST_DATABASE_INSTANCE 
SELECT ON SYS.DBA_HIST_SNAPSHOT 
ADVISOR 

AWR Report can be generated using:-

1. awrrpt.sql (This sql file is under rdbms/admin folder).
2. Using OEM
3. Using dbms_workload_repository package.

No comments:

Post a Comment