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 ofdirect path writewait events. Which two actions could
improve the performance? (Choose two.)
A.
increasing the value of theSORT_AREA_SIZEparameter
B.
increasing the value of thePGA_AGGREGATE_TARGETparameter
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
let’s say
B – because increase in the number of multipass work areas
E – because parallel_degree_policy is set to Manual meaning parallel execution is disabled and has to be enabled through the hint
B,C
Question is about dedicated server connections
C- cant be the answer (applicable to shared server by using large pool)
IMO BE
BC, no matter shared or dedicated imo