Users in your PROD database complain about the slow response of the transactions. While
investigating the reason, you find that the transactions are waiting for the undo segments to
be available, and undo retention has been set to zero. What would you do to overcome this
problem?
A.
increase the undo retention
B.
create more undo segments
C.
create another undo tablespace
D.
increase the size of the undo tablespace
undo_retention + force user wait => variable undo tablespace, auto tune undo_retention to support transaction.