Oracle
1Z0-052 · Question #121
1Z0-052 Question #121: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-052 to reveal the answer and full explanation for question #121. The question stem and answer options stay visible for context.
Performing Database Maintenance
Question
Your database instance is functional for the past one month. The Automatic Workload Repository (AWR) snapshot retention is set to 7 and the STATISTICS_LEVEL initialization parameter is set to TYPICAL. You receive a complaint about the poor performance of the database between 7 PM and 9 PM of the previous day. Choose two actions any of which can be referred to first to diagnose the problem. (Choose two.)
Options
- AUse the Active Session History report.
- BUse the AWR Compare Periods report.
- CUse an ADDM analysis between 7 PM and 9 PM of the previous day.
- DUse the AWR Compare Period report between 7 PM and 9 PM of the previous day.
Unlock 1Z0-052 to see the answer
You've previewed enough free 1Z0-052 questions. Unlock 1Z0-052 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.
Topics
#AWR snapshots#ADDM#Active Session History#performance diagnosis