Get ADDM Report in Text Manually in Oracle Database

Get ADDM Report in Text Manually in Oracle Database

Get Snap ID 

set linesize 190

select SNAP_ID,BEGIN_INTERVAL_TIME,END_INTERVAL_TIME from DBA_HIST_SNAPSHOT; 

Create Task

BEGIN
DBMS_ADVISOR.CREATE_TASK (
ADVISOR_NAME => 'ADDM',
TASK_NAME => 'Amit_addm_task',
TASK_DESC => 'Advisor for snapshots 675 to 759.');
DBMS_ADVISOR.SET_TASK_PARAMETER (
TASK_NAME => 'Amit_addm_task',
PARAMETER => 'START_SNAPSHOT', VALUE => 675);
DBMS_ADVISOR.SET_TASK_PARAMETER (
TASK_NAME => 'Amit_addm_task',
PARAMETER => 'END_SNAPSHOT', VALUE => 759);
DBMS_ADVISOR.EXECUTE_TASK(TASK_NAME => 'Amit_addm_task');
END;
/

Get Report

SELECT DBMS_ADVISOR.GET_TASK_REPORT('Amit_addm_task') AS REPORT FROM DUAL;

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;