View the Exhibit that shows your investigation on degraded performance.
What would you do? (Choose all that apply.)
A.
Shrink the temporary segment.
B.
Keep the large tables in the KEEP pool.
C.
Use free list groups wherever applicable.
D.
Increase the value set to the PGA_AGGREGATE_TARGET parameter.
E.
Switch the segments to Automatic Segment Space Management (ASSM).
If the contention is on tables or indexes (not the segment header) consider using ASSM, global hash partitioned indexes, or increasing free lists to avoid multiple processes attempting to insert into the same block.