ADDM report

As soon as each snapshot is generated, the addm-related background process starts automatically, and an addm report is generated after startup. When there is no problem, there is nothing in the automatically generated addm report.

In em, if the value after ADDM Findings is greater than 0, there is a reminder in the ADDM report.

Home- > Diagnostic Summary- > ADDM Findings (value greater than 0)

The method of generating ADDM comparison report of two SNAP

To manually generate an ADDM during two historically non-adjacent snap_shot, use @? / rdbms/admin/addmrpt.sql

SQL > @? / rdbms/admin/addmrpt.sql

The format of the generated report is txt format by default. If the html suffix name is forced during the generation process, the generated report will be opened in a browser with an unfriendly interface, which is not as good as txt format.

Query the statement of ADDM corresponding to SNAP

Select task_id,task_name,description from dba_advisor_tasks order by 1 desc

Export the latest ADDM report (requires sys users)

Select dbms_advisor.get_task_report (task_name) from dba_advisor_tasks

Where task_id = (

Select max (t.task_id) from dba_advisor_tasks t, dba_advisor_log l where

T.task_id=l.task_id and t.advisorship nameplate ADDM' and l.statussubmission)

Export an ADDM report for a task_id (sys user is required)

Select dbms_advisor.get_task_report (task_name) from dba_advisor_tasks where task_id = XX

Export a report with a task_name name of ADDM:1866763731_1_31374 (sys user required)

Select dbms_advisor.get_task_report ('ADDM:1866763731_1_31374') from dual