The performance of your database degrades between 11:00 AM and 3:00 PM. Automatic Workload
Repository (AWR) snapshots are collected on an hourly basis.
What is the most efficient way of diagnosing this problem?
A.
Create a custom ADDM task for the period defined by the snapshots taken between 11:00 AM and 3:00
PM.
B.
Analyze the latest Automatic Database Diagnostic Monitor (ADDM) report.
C.
Analyze the hourly ADDM reports generated between 11:00 AM and 3:00 PM.
D.
Create a SQL Tuning Set (STS) for the currently cached SQL statements in the shared pool and run SQL
Performance Analyzer (SPA) to generate recommendations.