You are administering a database that supports a DSS workload. Automatic Shared Memory Management is
enabled for the database instance. Users issue queries to perform large 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 the PGA_AGGREGATE_TARGET parameter.
C.
Create a temporary tablespace group and assign it to users.
D.
Increase the value of the PGA_AGGREGATE_LIMIT parameter.
E.
Create another temporary tablespace and assign it to users.
F.
Enable temporary undo.