How do you change the UNDO_RETENTION value?

You have a production instance running on your server. UNDO_RETENTION is not long
enough to satisfy read-consistency requirements. How do you change the
UNDO_RETENTION value?

You have a production instance running on your server. UNDO_RETENTION is not long
enough to satisfy read-consistency requirements. How do you change the
UNDO_RETENTION value?

A.
by executing UPDATE.. statement on V$PARAMETER to change the value of
UNDO_RETENTION

B.
by executing the ALTER SYSTEM .. command

C.
by re-creating the control file with a new value for UNDO_RETENTION

D.
by executing the ALTER DATABASE.. command in the MOUNT state



Leave a Reply 1

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


Leloush

Leloush

B
Change UNDO_RETENTION at any time using the ALTER SYSTEM statement:
ALTER SYSTEM SET UNDO_RETENTION = X;