Examine the parameters set for a database instance:
The database supports a mixed workload. Users complain about the increased response time
of a few DSS queries. During investigation, you execute the query:
Based on the output, which two are possible ways to improve the performance of the
queries?(Choose two.)
A.
Enable temporary undo.
B.
Enable Automatic Memory Management.
C.
Increase the number of DBWnprocesses.
D.
Enable Automatic Shared Memory Management.
E.
Increase the value of theSGA_TARGETparameter.
F.
Increase the value of thePGA_AGGREGATE_TARGETparameter.
imo B and F – right.
Lots of “workarea executions – multipass” means that the server is pressed with PGA.
We need to increase it or use AMM to redistribute the memory between PGA and SGA accordingly
B and F
Right, B and F. Workarea is part of the PGA, so this needs to be increased to get rid of multipass executions.
B & F clearly
BF