OCP CBT Question 675

Please solve the following question.

You observe a significant performance degradation in your Oracle database over the last few hours. You need to quickly identify the root cause of the performance issue and gather diagnostic information. Which Oracle feature would you use to generate a comprehensive report of the database's performance during a specific time interval?

SQL Trace (10046 Event)

Automatic Workload Repository (AWR) Report

Active Session History (ASH)

DBMS_STATS package