Which two statements are true about Automatic Database Diagnostic Monitor (ADDM)?

Which two statements are true about Automatic Database Diagnostic Monitor (ADDM)?
A. It calls SQL advisors automatically if required.
B. It provides recommendations only for poorly performing SQL statements.
C. Its results are stored in AWR.
D. It runs automatically after each AWR snapshot is created and requires at least two snapshots for analysis.
E. It requires at least one Automatic Workload Repository (AWR) snapshot for analysis.

Download Printable PDF. VALID exam to help you PASS.

2 thoughts on “Which two statements are true about Automatic Database Diagnostic Monitor (ADDM)?

  1. D is correct but C is not correct option.
    ADDM report itself will generate report based on AWR snapshots , then how come ADDM results stored in AWR.

Leave a Reply

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


The reCAPTCHA verification period has expired. Please reload the page.