Oracle Database 12c: Installation and Administration — Question 62

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?

Answer options

• 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

Correct answer: A

Explanation

The correct answer, A, is efficient because it focuses specifically on the time frame when performance issues are observed, allowing for targeted analysis. Option B is less effective as it only looks at the latest report, which may not capture the relevant time frame. Option C, while useful, may not be as efficient as creating a custom task. Option D is unrelated to the time-specific performance degradation and focuses on SQL tuning rather than overall workload analysis.