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.
B,C
C,D – PGA_AGGREGATE_TARGET <= PGA_AGGREGATE_LIMIT on 12c
Maybe D,E
because TEMPORARY TABLESPACE GROUP should be created previuosly and now we can extend it with another tablespace in same group.
IMO CD
B, C