Which two actions could improve the performance?

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

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



Leave a Reply 0

Your email address will not be published. Required fields are marked *