1Z0-060 · Question #174
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…
The correct answer is A. It shows the resource usage for CPU, memory, and I/O in both time periods. B. It identifies any workload change that caused a performance difference in both time periods C. It detects any configuration change that caused a performance difference 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.
How the community answered
(24 responses)- A71% (17)
- D21% (5)
- E8% (2)
Why each option
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.
The compare period ADDM report provides a side-by-side breakdown of CPU, memory, and I/O resource consumption across both time periods, enabling administrators to identify where resource usage diverged.
The report specifically identifies workload changes between the two periods - such as shifts in SQL execution frequency, new SQL statements, or changes in application activity - and correlates them with observed performance differences.
Compare period ADDM detects database and system configuration changes such as initialization parameter modifications, schema alterations, or optimizer statistics refreshes and links them to performance impact across the two periods.
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.
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
Source: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/tgdba/comparing-database-performance-over-time.html
Topics
Community Discussion
No community discussion yet for this question.