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