set heading off;
set feedback off;
set linesize 1500;
select snap_id,dbid,begin_interval_time,end_interval_time from DBA_HIST_SNAPSHOT
order by 1;
replace your snap_id and dbid wtih following sql:
spool awr.html
select output from
table(dbms_workload_repository.awr_report_html(dbid,1,
spool off
Hiç yorum yok:
Yorum Gönder