nerdexam
Oracle

1Z0-062 · Question #133

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

The correct answer is B. The ADDM runs after each AWR snapshot is collected automatically by MMON C. The results of the ADDM analysis are stored in the Automatic Workload Repository (AWR). ADDM automatically runs after every AWR snapshot via the MMON background process, and its findings are stored in the AWR for later review.

Managing Performance

Question

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

Options

  • AThe ADDM requires at least four AWR snapshots for analysis
  • BThe ADDM runs after each AWR snapshot is collected automatically by MMON
  • CThe results of the ADDM analysis are stored in the Automatic Workload Repository (AWR)
  • DThe ADDM analysis provides only diagnostics information but does not provide recommendations
  • EThe ADDM calls other advisors if required, but does not provide recommendations about the

How the community answered

(34 responses)
  • B
    94% (32)
  • D
    3% (1)
  • E
    3% (1)

Why each option

ADDM automatically runs after every AWR snapshot via the MMON background process, and its findings are stored in the AWR for later review.

AThe ADDM requires at least four AWR snapshots for analysis

ADDM requires only two AWR snapshots - a begin and an end snapshot - to define the analysis period, not four.

BThe ADDM runs after each AWR snapshot is collected automatically by MMONCorrect

The Manageability Monitor (MMON) background process automatically triggers an ADDM analysis immediately after each AWR snapshot is taken, requiring no manual intervention to diagnose performance issues.

CThe results of the ADDM analysis are stored in the Automatic Workload Repository (AWR)Correct

ADDM analysis results, including findings, impact estimates, and recommendations, are stored directly in the Automatic Workload Repository (AWR), making them accessible through Enterprise Manager or the DBMS_ADDM package.

DThe ADDM analysis provides only diagnostics information but does not provide recommendations

ADDM does provide actionable recommendations, not just diagnostics; it recommends specific fixes such as SQL tuning, index creation, or memory resizing.

EThe ADDM calls other advisors if required, but does not provide recommendations about the

ADDM both calls other advisors (such as the SQL Tuning Advisor) and provides its own recommendations based on the analysis findings.

Concept tested: ADDM automatic execution and AWR integration

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/tgdba/automatic-performance-diagnostics.html

Topics

#ADDM#AWR#performance diagnostics#MMON

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-062 Practice