Which two actions would you take to solve this problem?

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

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

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.



Leave a Reply 0

Your email address will not be published. Required fields are marked *