Which three methods can you use to run an Automatic Database Diagnostic Monitor
(ADDM) analysis over a specific time period? (Choose three.)
A.
Enterprise Manager GUI
B.
DBMS_TRACE package APIs
C.
DBMS_ADVISOR package APIs
D.
DBMS_MONITOR package APIs
E.
$ORACLE_HOME/rdbms/admin/addmrpt.sql script
Explanation:
————–
To make use of ADDM, a PL/SQL interface called DBMS_ADVISOR has been implemented.
This PL/SQL interface may be called through the supplied
$ORACLE_HOME/rdbms/admin/addmrpt.sql script, called directly, or used in combination
with the Oracle Enterprise Manager application. Besides this PL/SQL package a number of
views (with names starting with the DBA_ADVISOR_ prefix) allow retrieval of the results ofany actions performed with the DBMS_ADVISOR API. The preferred way of accessing
ADDM is through the Enterprise Manager interface, as it shows a complete performance
overview including recommendations on how to solve
bottlenecks on a single screen. When accessing ADDM manually, you should consider using
the ADDMRPT. SQL script provided with your Oracle release, as it hides the complexities
involved in accessing the DBMS_ADVISOR package.