Which three methods can you use to run an Automatic Database Diagnostic Monitor (ADDM) analysis over a specifi

Next Question

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 of any 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.

Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *