Which three methods can you use to run an Automatic Database Diagnostic Monitor (ADDM) analysis over a specific time period?

Which three methods can you use to run an Automatic Database Diagnostic Monitor (ADDM)
analysis over a specific time period? (Choose three.)

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.



Leave a Reply 0

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