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 ofdirect path writewait 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 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



Leave a Reply 4

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


vasya

vasya

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

srks

srks

Question is about dedicated server connections
C- cant be the answer (applicable to shared server by using large pool)

IMO BE

Fonx

Fonx

BC, no matter shared or dedicated imo