Which two statements are true about Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)
Which two statements are true about Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)
Automatic Database Diagnostic Monitor (ADDM) provides detailed analysis and recommendations for database performance issues. Two true statements about ADDM are that its results are stored in the Automatic Workload Repository (AWR), and it runs automatically after each AWR snapshot is created, requiring at least two snapshots for its analysis. This allows ADDM to compare different performance metrics between snapshots to identify and suggest improvements.
ADDM requires at least two snapshots to perform analysis. Answer is CD.
Answer: CD
Answer is CD
https://docs.oracle.com/database/121/TDPPT/tdppt_auto.htm#TDPPT025 In above page there is a a sentence below, which indicates at least 2 AWR snapshoot must be present to run "addmrpt.sql" for ADDM. So D is correct E is incorrect.
Answer is: C and D reference : https://docs.oracle.com/database/121/TDPPT/tdppt_auto.htm#TDPPT025
https://docs.oracle.com/en/database/oracle/oracle-database/19/tgdba/automatic-performance-diagnostics.html#GUID-AEE549F3-DDF9-4977-8A0A-FE1E47C75679 ADDM can analyze any two AWR snapshots (on the same database), as long as ...
C & E correct ref: https://docs.oracle.com/database/121/TDPPT/tdppt_auto.htm#TDPPT301
Answer: CE An ADDM analysis is performed after each AWR snapshot (every hour by default), and the results are saved in the database. ref: https://docs.oracle.com/database/121/TDPPT/tdppt_auto.htm#TDPPT301
The data in the snapshot interval is analyzed by ADDM. ADDM compares the differences between snapshots to determine which SQL statements to capture, based on the effect on the system load. The ADDM analysis shows the number of SQL statements that need to be captured over time. ref: https://docs.oracle.com/database/121/TDPPT/tdppt_auto.htm#TDPPT025 Answer: CD
CD is an answer
I think C,D
I think it's C and E. It requires 2 snapshots if addm is run manually, true. But it says in document "ADDM analysis results that are automatically created each time an AWR snapshot is taken." which seems means even one AWR snapshot is enough for he automatic ADDM run. Option D is partially correct, ADDM does get generaed automatically