1Z0-062 · Question #209
Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)?
The correct answer is A. It runs automatically after each AWR snapshot is created and it requires at least two snapshots C. It calls SQL advisors automatically if required.. The Automatic Database Diagnostic Monitor (ADDM) automatically runs after each AWR snapshot is created, requiring at least two snapshots for analysis, and can initiate SQL advisors for detected performance issues.
Question
Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)?
Options
- AIt runs automatically after each AWR snapshot is created and it requires at least two snapshots
- BIts results are stored in AWR.
- CIt calls SQL advisors automatically if required.
- DIt provide recommendations only for poorly performing SQL statements.
- EIt requires at least one AWR snapshot for analysis.
How the community answered
(53 responses)- A89% (47)
- B2% (1)
- D4% (2)
- E6% (3)
Why each option
The Automatic Database Diagnostic Monitor (ADDM) automatically runs after each AWR snapshot is created, requiring at least two snapshots for analysis, and can initiate SQL advisors for detected performance issues.
ADDM processes performance data gathered by AWR snapshots, needing at least a pair of snapshots (start and end) to analyze a time period, and it executes automatically after each snapshot is created.
While ADDM findings are stored in views within the AWR repository, AWR itself is the source of the performance data ADDM analyzes, not strictly the storage location for its derived results in the same conceptual way it stores raw snapshots.
A key feature of ADDM is its ability to diagnose SQL-related performance problems and recommend or even automatically initiate SQL advisors, such as the SQL Tuning Advisor, for deeper analysis.
ADDM provides comprehensive recommendations for various performance bottlenecks, including CPU, I/O, memory, and concurrency issues, not exclusively for poorly performing SQL statements.
ADDM requires a minimum of two AWR snapshots (a starting and an ending snapshot) to define the time interval over which it performs its diagnostic analysis.
Concept tested: ADDM functionality and AWR integration
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/tgsql/automatic-database-diagnostic-monitor.html#GUID-EDBE07D0-5020-410C-B39C-CD5E7B79D558
Topics
Community Discussion
No community discussion yet for this question.