nerdexam
Oracle

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.

Managing Performance

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)
  • A
    89% (47)
  • B
    2% (1)
  • D
    4% (2)
  • E
    6% (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.

AIt runs automatically after each AWR snapshot is created and it requires at least two snapshotsCorrect

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.

BIts results are stored in AWR.

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.

CIt calls SQL advisors automatically if required.Correct

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.

DIt provide recommendations only for poorly performing SQL statements.

ADDM provides comprehensive recommendations for various performance bottlenecks, including CPU, I/O, memory, and concurrency issues, not exclusively for poorly performing SQL statements.

EIt requires at least one AWR snapshot for analysis.

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

#ADDM#AWR snapshots#SQL advisors#performance analysis

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice