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