declare
begin_time_date date := to_date('20141130 23:00:00', 'yyyymmdd hh24:mi:ss') ;
end_time_date date := to_date('20141203 18:00:00', 'yyyymmdd hh24:mi:ss') ;
begin
dbms_output.put_line('set linesize 2000');
dbms_output.put_line('set pagesize 50000');
dbms_output.put_line('set head off');
for r in (select *
from sys.WRM$_SNAPSHOT t
where t.begin_interval_time >begin_time_date
and t.begin_interval_time< end_time_date
and t.dbid=3628304518
order by t.snap_id, t.instance_number)
loop
dbms_output.put_line('spool awrrpt_' || r.instance_number || '_' ||
to_char(r.begin_interval_time+1/24,'mmdd_hh24mi') || '_' ||to_char(r.end_interval_time+1/24,'mmdd_hh24mi') || '.html');
dbms_output.put_line('select *
from table
(dbms_workload_repository.awr_report_html(' ||
r.dbid || ',' || r.instance_number || ',' ||
r.snap_id || ',' || (r.snap_id + 1) || ',0));');
dbms_output.put_line('spool off');
end loop;
end;
快速收集AWR性能报告的脚本
最新推荐文章于 2021-01-12 20:11:45 发布