Wednesday, October 17, 2012

Compare AWR periods


First list available AWR snapshots

select snap_id, end_interval_time
from dba_hist_snapshot
where end_interval_time > trunc(sysdate-10)
order by snap_id;


Then run this sql to generate HTML report with differences

select * from table(dbms_workload_repository.awr_diff_report_html(3663464033,1,8249,8250,3663464033,1,8417,8418));

No comments:

Post a Comment