1.查看snapid、dbid
select dbid from v$database;
select to_char(s.startup_time,'dd Mon "at" HH24:mi:ss') instart_fmt
, di.instance_name inst_name
, di.db_name db_name
, s.snap_id snap_id
, to_char(s.end_interval_time,'dd Mon YYYY HH24:mi') snapdat
, s.snap_level lvl
from dba_hist_snapshot s
, dba_hist_database_instance di
where di.dbid = s.dbid
and di.instance_number = s.instance_number
and di.startup_time = s.startup_time
order by db_name, instance_name, snap_id;
2.执行命令查看awr的到报告原本
4个值,第一个dbid,第二个不管,最后2个snapid
select * from table(dbms_workload_repository.awr_report_html('1435211751',1,8013,8014));
3、将查询得到的awr报告复制到文本文件并保存为html格式即可得到awr报告
不要用plsql里的导出成html,直接复制出来到txt,然后改html即可。