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 *