Which two statements are true about the Automatic Datab…

In your database, the STATISTICS_LEVEL parameter is set to TYPICAL and an Automatic
Workload Repository (AWR) snapshot is taken every 30 minutes.
Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)

In your database, the STATISTICS_LEVEL parameter is set to TYPICAL and an Automatic
Workload Repository (AWR) snapshot is taken every 30 minutes.
Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)

A.
It measures database performance by analyzing the wait time and CPU time of all non-idle user sessions.

B.
It always compares the latest snapshot with the baseline snapshot for analysis.

C.
It runs after each AWR snapshot is created and it requires at least two snapshots for analysis.

D.
It requires at least four AWR snapshots for analysis.

E.
It calls other advisors if required, but does not provide recommendations about the advisors to be used.



Leave a Reply 1

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