1Z0-062 · Question #185
In your database, the STATISTICS_LEVEL parameter is set to TYPICAL and a Automatic Workload Repository (AWR) snapshot is taken every 30 minutes. Which two statements are true about the Automatic Datab
The correct answer is A. It runs after each AWR snapshot is created and it requires at least two snapshots for analysis. B. It measures database performance by analyzing the wait time and CPU time of all non-idle user. ADDM automatically runs after every AWR snapshot, requires a minimum of two snapshots to perform its analysis, and evaluates performance by examining DB time broken into wait time and CPU time for non-idle sessions.
Question
In your database, the STATISTICS_LEVEL parameter is set to TYPICAL and a Automatic Workload Repository (AWR) snapshot is taken every 30 minutes. Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)?
Options
- AIt runs after each AWR snapshot is created and it requires at least two snapshots for analysis.
- BIt measures database performance by analyzing the wait time and CPU time of all non-idle user
- CIt calls other advisors if required, but does not provide recommendations about the advisors to be
- DIt always compares the latest snapshot with the baseline snapshot for analysis.
- EIt requires at least four AWR snapshots for analysis.
How the community answered
(48 responses)- A94% (45)
- D2% (1)
- E4% (2)
Why each option
ADDM automatically runs after every AWR snapshot, requires a minimum of two snapshots to perform its analysis, and evaluates performance by examining DB time broken into wait time and CPU time for non-idle sessions.
ADDM is triggered automatically after each AWR snapshot is taken and performs its analysis by comparing two consecutive snapshots, meaning at least two snapshots must exist before any ADDM findings can be generated.
ADDM quantifies database performance issues in terms of DB time, which it decomposes into CPU time and wait time for non-idle user sessions, allowing it to identify and rank the top bottlenecks consuming the most DB time during the analysis period.
ADDM does call other advisors such as the SQL Tuning Advisor and Segment Advisor, and it also explicitly provides recommendations that reference those advisors as part of its findings output.
By default, ADDM compares the two most recent consecutive AWR snapshots rather than always comparing against a baseline snapshot; baseline comparison is an optional, user-directed analysis.
ADDM requires a minimum of two AWR snapshots, not four, to perform its performance analysis between the start and end snapshot of an analysis period.
Concept tested: ADDM operation, triggers, and DB time analysis with AWR
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/tgdba/automatic-database-diagnostic-monitor.html
Topics
Community Discussion
No community discussion yet for this question.