Databases Reference
In-Depth Information
We can see the reports with SQL*Plus using the
DBMS_ADDM.GET_REPORT
function, which
returns a CLOB containing the report (80-columns formatted), or we can use Oracle Enterprise
Manager to view the reports generated both in automatic or manual mode. In OEM, we can
view ADDM findings in the homepage in the Diagnostic Summary information. We can choose
Advisor Central on the bottom of the page to see a list of the ADDM reports available, as
shown in the following screenshot:
