Which two can be possible resolutions for this issue?

You are administering a database that supports a DSS workload. Automatic Shared Memory
Management is enabled for the database instance. Users issue queries toperformlarge soft
operations and complain about degraded performance of the queries. On investigation, you
notice that the queries are performing multipass work area executions and the I/O contention
on one of the temporary tablespaces is very high. Which two can be possible resolutions for
this issue?(Choose two.)

You are administering a database that supports a DSS workload. Automatic Shared Memory
Management is enabled for the database instance. Users issue queries toperformlarge soft
operations and complain about degraded performance of the queries. On investigation, you
notice that the queries are performing multipass work area executions and the I/O contention
on one of the temporary tablespaces is very high. Which two can be possible resolutions for
this issue?(Choose two.)

A.
Increase the size of the large pool.

B.
Increase the value of thePGA_AGGREGATE_TARGETparameter.

C.
Create a temporary tablespace group and assign it to users.

D.
Increase the value of thePGA_AGGREGATE_LIMITparameter.

E.
Create another temporary tablespace and assign it to users.

F.
Enable temporary undo.



Leave a Reply 5

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


diablo

diablo

C,D – PGA_AGGREGATE_TARGET <= PGA_AGGREGATE_LIMIT on 12c

diablo

diablo

Maybe D,E
because TEMPORARY TABLESPACE GROUP should be created previuosly and now we can extend it with another tablespace in same group.