通过PLSQLDEV获取AWR报告的方法:
远程取出AWR报告
取出AWR报告的办法
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得到报告文本
select * from table(dbms_workload_repository.awr_report_html('1435211751',1,8013,8014));
3、将查询得到的awr报告复制到文本文件并保存为html格式即可得到awr报告