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.