What would you do to overcome this problem?

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?

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



Leave a Reply 1

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