which two are possible ways to improve the performance …

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

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.



Leave a Reply 5

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


vasya

vasya

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

Larisa

Larisa

Right, B and F. Workarea is part of the PGA, so this needs to be increased to get rid of multipass executions.

Fonx

Fonx

B & F clearly