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 DBWn processes.

D.
Enable Automatic Shared Memory Management.

E.
Increase the value of the SGA_TARGET parameter.

F.
Increase the value of the PGA_AGGREGATE_TARGET parameter.



Leave a Reply 0

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