AWR Report Generation

We can generate AWR report using view.

1. select date and time

select  snap_id || '=' || dbid || '=' || instance_number || '=' || to_char(end_interval_time, 'DD/MON/YYYY HH24:MI:SS')  as awrreport from    dba_hist_snapshot order by end_interval_time desc;

2. generate AWR report providing above information in below DBMS package

select * from table(dbms_workload_repository.awr_global_report_html(<DBID>,<INSTANCE_NUMBER>,<BEGIN_SNAPID>,<END_SNAPID>,<OPTIONS>);

Note: Instance_number = null for RAC or global AWR report.

select * from table(dbms_workload_repository.awr_global_report_html(<DBID>,null,<BEGIN_SNAPID>,<END_SNAPID>,0);

Example: Instance 1

select * from table(dbms_workload_repository.awr_global_report_html(<DBID>,1,<BEGIN_SNAPID>,<END_SNAPID>,0);