Oracle
1Z0-064 · Question #5
1Z0-064 Question #5: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-064 to reveal the answer and full explanation for question #5. The question stem and answer options stay visible for context.
Question
Examine the parameters: Your database supports a mixed workload and users have dedicated server connections. Users complain about the increased response time of a few queries that are performing large sort operations. On investigation, you notice an increase in the number of multipass work area executions and high number of direct path write wait events. Which two actions could improve the performance? (Choose two.)
Exhibit
Options
- Aincreasing the value of the SORT_AREA_SIZE parameter
- Bincreasing the value of the PGA_AGGREGATE_TARGET parameter
- Cenabling Automatic Memory Management for the instance
- Dincreasing the size of the default temporary tablespace
- Eusing parallel hint in queries performing large sort operations
- Fenabling Automatic Shared Memory Management for the instance
Unlock 1Z0-064 to see the answer
You've previewed enough free 1Z0-064 questions. Unlock 1Z0-064 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.