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.)
A. increasing the value of the SORT_AREA_SIZE parameter
B. increasing the value of the PGA_AGGREGATE_TARGET parameter
C. enabling Automatic Memory Management for the instance
D. increasing the size of the default temporary tablespace
E. using parallel hint in queries performing large sort operations
F. enabling Automatic Shared Memory Management for the instance
|
Download Printable PDF. VALID exam to help you PASS. |
 |