1Z0-078 practice question 14 of 15

Which three statements are true concerning Automatic Database Diagnostic Monitor (ADDM) for RAC? (Choose three.)

Full set: 77 questions

Answer options

A: It can analyze performance over any given time period. Correct answer

B: It can diagnose skew in response time. Correct answer

C: It can analyze performance using data captured on all instances. Correct answer

D: It can only analyze performance on the instance running the ADDM job.

E: It can diagnose latency problems in the Cluster Interconnect.

F: It runs automatically in Instance ADDM mode after each AWR snapshot is created.

Correct Answer:

A. It can analyze performance over any given time period.; B. It can diagnose skew in response time.; C. It can analyze performance using data captured on all instances.

Explanation

ADDM for RAC lets you specify any pair of AWR snapshots, analyses data collected on all RAC instances, and highlights cluster-wide issues such as load or response-time skew between instances.

Why Incorrect

D. Database-level ADDM can examine all instances, not only the one that launches the task.
E. Interconnect latency is reported by Cluster Health Monitor and GC wait events, not directly diagnosed by ADDM.
F. Automatic runs after each snapshot occur only in Instance-ADDM mode, not in RAC-wide ADDM analysis.

References

1. Oracle® Database 19c Performance Tuning Guide, Sec. 23.2.3 “Running ADDM in Oracle RAC”, p.23-20

2. ibid., Example 23-5 (“Begin/End Snapshot parameters let you analyze any period”)

3. ibid., “Detecting Load or Response-Time Skew Across Instances”, p.23-22

Keep practicing

Take the free 1Z0-078 practice test

Ten exam-style questions with answers and explanations, plus the exam facts and study guides.

Start the free practice test