Oracle
1Z0-060 · Question #231
1Z0-060 Question #231: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-060 to reveal the answer and full explanation for question #231. The question stem and answer options stay visible for context.
Question
The workload on your database remains the same between 9 AM and 6 PM on all days of the week. However, you notice performance degradation between 3 PM and 5 PM on some days. You want to identify regressed statements by comparing the workload between these two periods. Examine these steps: 1. Create a SQL Tuning Set (STS) for the statements cached in the library cache for both periods. 2. Generate a Compare Period AWR report for both periods. 3. Run the SQL Performance Analyzer (SPA) on the STS captured for both periods. 4. Run the SQL Tuning Analyzer on the STS captured for both periods. 5. Run the SQL Access Advisor on the STS captured for both periods. 6. Run the Compare Period ADDM report for both periods. Identify the required steps to accomplish the task.
Options
- A1 and 3
- B1 and 5
- C1 and 2
- Donly 6
- E1 and 4
- Fonly 2
Unlock 1Z0-060 to see the answer
You've previewed enough free 1Z0-060 questions. Unlock 1Z0-060 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.