Oracle Database 12c: Installation and Administration — Question 143

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 generates lots of redo.
Which two actions would you take to solve this problem? (Choose two.)

Answer options

• A. Increase the size of the temporary tablespace.
• B. Enable Automatic Memory Management (AMM).
• C. Enable undo retention guarantee.
• D. Enable temporary undo for the database.
• E. Increase the size of the redo log buffer.

Correct answer: A, D

Explanation

Increasing the size of the temporary tablespace (A) allows for more space to handle the temporary data created during transactions, thus reducing the pressure on the undo tablespace. Enabling temporary undo (D) helps manage the undo data specifically for temporary tables, further alleviating the issue. The other options do not directly address the high undo and redo generation associated with temporary tables.