Oracle的AWR

--查看awr快照历史
SELECT *
  FROM DBA_HIST_SNAPSHOT T
 WHERE T.END_INTERVAL_TIME >=
       TO_DATE('2019-11-15 09:00:00', 'yyyy-MM-dd hh24:mi:ss')
   AND T.END_INTERVAL_TIME <=
       TO_DATE('2019-11-15 10:01:00', 'yyyy-MM-dd hh24:mi:ss')
 ORDER BY SNAP_ID;



手动导出awr，保存为html查看
SELECT *
  FROM TABLE(DBMS_WORKLOAD_REPOSITORY.AWR_REPORT_HTML(1700577032,
                                                      1,
                                                      38247,
                                                      38251,
                                                      0));
或者：
SELECT DBMS_WORKLOAD_REPOSITORY.AWR_REPORT_HTML(1700577032,
                                                      1,
                                                      38247,
                                                      38251,
                                                      0) FROM dual;    

-- 查看awr配置
 select DBID, SNAP_INTERVAL, SNAPINT_NUM, RETENTION from wrm$_wr_control;

-- 设置awr配置，30代表30分钟 11520为7*24*60
 execute dbms_workload_repository.modify_snapshot_settings(interval => 30,retention => 10080); 

-- 手动创建一个快照
begin
  dbms_workload_repository.create_snapshot();
  end;
  /

-- sqlplus生成awr报告
@?/rdbms/admin/awrrpt.sql