Oracle
1Z0-054 · Question #199
You are working in a dedicated server environment. You discovered that your database performance is degraded due to a huge number of sort operations that are using the disk space instead of the…
The correct answer is B. setting the PGA_AGGREGATE_TARGET parameter to a higher value. See the full explanation below for the reasoning.
Question
You are working in a dedicated server environment. You discovered that your database performance is degraded due to a huge number of sort operations that are using the disk space instead of the memory area. The WORKAREA_SIZE_POLICY parameter is set to AUTO. What would be one of the solutions to improve database performance?
Options
- Asetting the *_AREA_SIZE parameters to higher values
- Bsetting the PGA_AGGREGATE_TARGET parameter to a higher value
- Csetting the SORT_AREA_RETAINED_SIZE parameter to a lower value
- Dsetting the SORT_AREA_RETAINED_SIZE parameter to a higher value
How the community answered
(25 responses)- A16% (4)
- B72% (18)
- C8% (2)
- D4% (1)
Community Discussion
No community discussion yet for this question.