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.)

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.)

Accepted Answer

A. increasing the value of the SORT_AREA_SIZE parameter F. enabling Automatic Shared Memory Management for the instance

Answer

B. increasing the value of the PGA_AGGREGATE_TARGET parameter

Answer

C. enabling Automatic Memory Management for the instance

Answer

D. increasing the size of the default temporary tablespace

Answer

E. using parallel hint in queries performing large sort operations

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…

Question

Exhibit

Options

How the community answered

Community Discussion