Upgrade Oracle DBA 11g to Oracle Database 12c — Question 39

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) helps optimize memory usage, which can alleviate the pressure on undo tablespace. Increasing the size of the temporary tablespace ensures that the application has enough space for its operations, reducing undo consumption. The other options either do not directly address the undo tablespace issue or are not relevant to the scenario described.