Oracle
1Z0-060 · Question #174
1Z0-060 Question #174: Real Exam Question with Answer & Explanation
The correct answer is A: It shows the resource usage for CPU, memory, and I/O in both time periods.. The compare period ADDM report analyzes two AWR snapshot ranges to surface resource usage differences, workload shifts, and configuration changes that explain a performance change.
Question
You notice a performance change in your production Oracle 12c database and you want to know what change caused this performance difference. You generate the compare period Automatic Database Diagnostic Monitor (ADDM) report to further investigation. Which three findings would you get from the report?
Options
- AIt shows the resource usage for CPU, memory, and I/O in both time periods.
- BIt identifies any workload change that caused a performance difference in both time periods
- CIt detects any configuration change that caused a performance difference in both time periods.
- DIt gives information about statistics collection in both time periods.
- EIt detects the top wait events causing performance degradation.
Explanation
The compare period ADDM report analyzes two AWR snapshot ranges to surface resource usage differences, workload shifts, and configuration changes that explain a performance change.
Common mistakes.
- D. Statistics collection details are not a primary output of the compare period ADDM report; information about optimizer statistics gathering is available through separate AWR and data dictionary views.
- E. Top wait events are a finding of standard single-period ADDM analysis; compare period ADDM is specifically designed to explain performance differences between two periods, not to rank absolute wait events.
Concept tested. Compare period ADDM report findings and scope
Community Discussion
No community discussion yet for this question.