What is the most efficient way of diagnosing this problem?

The performance of your database degrades between 11 :00 AM and 3:00 PM, Automatic WorkloadRepository (AWR) snapshots are collected on an hourly basis.What is the most efficient way of diagnosing this problem?

Question:

What is the most efficient way of diagnosing this problem?

Options:

Create a custom ADDM task for the period defined by the snapshots taken between 11:00 AM and 3:00 PM.

Analyze the latest Automatic Database Diagnostic Monitor (ADDM) report.

Analyze the hourly ADDM reports generated between 11:00 AM and 3:00 PM.

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

Correct Answer

The Correct Answer for this Question is

Create a custom ADDM task for the period defined by the snapshots taken between 11:00 AM and 3:00 PM.