AWR views query

 

Query:

select to_char(s.startup_time, ' DD MON "at" HH24') INSTART_FMT, di.instance_name INST_NAME, di.db_name DB_NAME, s.snap_id SNAP_ID, to_char(s.end_interval_time, 'DD MON YYYY HH24:MI') SNAPDAT, s.snap_level LVL

from dba_hist_snapshot s, dba_hist_database_instance di where di.dbid=s.dbid and di.instance_number = s.instance_number and di.starti[_time=s.startup_time order by snap_id;

pull AWR report:

select * from table(dbms_workload_repository.awr_global_report_html(<dbid>,<instance_number>,<begin_snapid>,<end_snapid>,0));