{AWR}ADDMを実行

 

https://docs.oracle.com/cd/F19136_01/tgdba/automatic-performance-diagnostics.html#GUID-EA83D5B3-F4F0-4B4A-9597-19BBA22E55B9

 

select * from dba_hist_snapshot order by snap_id;

variable v varchar2(100);

BEGIN
DBMS_ADDM.ANALYZE_INST (
   task_name    =>:v,
   begin_snapshot   =>162,
   end_snapshot     =>163);
END;
/

SET LONG 1000000 PAGESIZE 0;
SELECT DBMS_ADDM.GET_REPORT(:v) FROM DUAL;