Generating AWR Reports


Of course DBAs can execute these procs and have permissions to generate reports. If you have a user that you trust to run AWR reports you can grant them SELECT_CATALOG_ROLE and
grant select_catalog_role to &user.;
grant execute on dbms_workload_repository to &user.;

AWR Reports


AWR Difference Report

A useful difference report between two AWR reports can be generated by running awrddrpt.sql or by using the API. If you run awrddrpt.sql then you will be prompted for all required information for the two snapshots you want to compare. Using the API:
select output 
  from table(dbms_workload_repository.awr_diff_report_html( 
    :bid, :eid,
    :bid2, :eid2