oracle生成AWR报告

执行SQL的时候请修改生成报告时间：

**************************************************************************************************************************************************************************

declare

v_begin_date date;

v_end_date date;

v_dbid number;

v_instance_number number;

v_min_snap_id number;

v_max_snap_id number;

begin

--设置要生成的报告的开始时间和结束时间

v_begin_date:=to_date('20160328 0530','yyyymmdd hh24mi');

v_end_date:=to_date('20160328 1130','yyyymmdd hh24mi');

--根据时间找到snap_id

select dbid,instance_number,min(snap_id),max(snap_id) into v_dbid,v_instance_number,v_min_snap_id,v_max_snap_id from dba_hist_snapshot

where end_interval_time>v_begin_date and end_interval_time<v_end_date

group by dbid,instance_number;

--加大dbms_output的buffer防止overflow

dbms_output.enable(500000);

DBMS_OUTPUT.ENABLE (buffer_size=>null) ;

--输出html文本

for i in (select output from table(dbms_workload_repository.awr_report_html(v_dbid, v_instance_number,v_min_snap_id,v_max_snap_id)))

loop

dbms_output.put_line(i.output);

end loop;

end;

**************************************************************************************************************************************************************************