Oracle Generate AWR Report Through SQL

oracle_awrrpt_sql.sql

-- Find the dbid, instance_number and begin and end snap_id to be used.

select
    snap_id,
    dbid,
    instance_number,
    begin_interval_time,
    end_interval_time
from
    dba_hist_snapshot
order by
    snap_id desc;


-- Plugin dbid, instance_number, begin stap_id and end_snap_id.

select
    output
from
    table(
        dbms_workload_repository.awr_report_text(
            l_dbid     => dbid,
            l_inst_num => instance_number,
            l_bid      => begin_interval_time,
            l_eid      => end_interval_time
        )
    );