Oracle Database Administration 2022 Certified Professional — Question 4

Database performance degraded between 23:15 and 23:30 for the last three nights. The AWR snapshot interval is one hour. The ADDM report contains nothing about this performance problem.
With which tool can you further analyze this problem?

Answer options

• A. SQL Performance Analyzer
• B. AWR Compare Periods report
• C. SQL Tuning Advisor
• D. Active Session History report

Correct answer: D

Explanation

The Active Session History report is the correct tool for analyzing real-time performance issues and can provide insights into sessions and wait events during the specified time frame. The SQL Performance Analyzer, AWR Compare Periods report, and SQL Tuning Advisor do not focus on real-time data and may not reveal the transient issues occurring between those specific times.