Oracle Database 12c: Advanced Administration — Question 72

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?

Answer options

• 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.

Correct answer: D, E

Explanation

Enabling Automatic Memory Management (AMM) allows the database to better allocate memory resources, which can help manage undo space more effectively. Increasing the size of the temporary tablespace provides more space for temporary operations, alleviating the pressure on the undo tablespace. The other options do not directly address the issue of high undo consumption or retention.