Compare ADDM Report in HTML format in Oracle Database

Compare ADDM Report in HTML format

Get snap id

set linesize 190
select SNAP_ID,BEGIN_INTERVAL_TIME,END_INTERVAL_TIME from DBA_HIST_SNAPSHOT; 

Compare Report

set long 1000000 longchunksize 1000000
set linesize 1000 pagesize 0
set echo off feedback off
spool addm_compare_report.html
SELECT DBMS_ADDM.COMPARE_INSTANCES (
BASE_INSTANCE_ID => 1,
BASE_BEGIN_SNAP_ID => &start_base_sanp_id,
BASE_END_SNAP_ID => &end_base_sanp_id,
COMP_INSTANCE_ID => 1,
COMP_BEGIN_SNAP_ID => &start_comp_sanp_id,
COMP_END_SNAP_ID => &end_comp_sanp_id,
REPORT_TYPE => 'HTML') AS report
FROM dual;
SPOOL OFF

Get Report in HTML

addm_compare_report.html

Get listed Tasks

SELECT

'TASK_ID: ' ||TASK_ID || CHR(10) ||

'TASK_NAME: ' ||TASK_NAME || CHR(10) ||

'DESCRIPTION: ' || SUBSTR(DESCRIPTION,1,60) || CHR(10) ||

'STATUS: ' ||STATUS || CHR(10) ||

'ACTIVITY_COUNTER: ' ||ACTIVITY_COUNTER || CHR(10) ||

'RECOMMENDATION_COUNT: ' ||RECOMMENDATION_COUNT AS INFO

FROM DBA_ADDM_TASKS

ORDER BY TASK_ID DESC FETCH FIRST 1 ROWS ONLY;