Your database supports an online transaction processing (OLTP) workload in which one of the applications creates a temporary table for a session and performs transactions on it.
This consumes a lot of undo tablespace and is affecting undo retention. Which two actions would you take to solve this problem?
A.
Enable temporary undo for the database.
B.
Enable undo retention guarantee.
C.
Increase the size of the redo log buffer.
D.
Enable Automatic Memory Management (AMM).
E.
Increase the size of the temporary tablespace.
D&E
DE
BE
I think A, E
AE is correct. I found this question in 1z0-062. Thank you
AE.
A > To user the feature, the parameter TEMP_UNDO_ENABLED must be TRUE.
E > The Oracle 12c introduced the concept of temporary undo, allowing the undo segments of temporary tables be stored in the temporary tablespace.
AE