which situation may the UNDO_RETENTION parameter be ignored, even if it is set to a value?

In which situation may the UNDO_RETENTION parameter be ignored, even if it is set to a
value?

In which situation may the UNDO_RETENTION parameter be ignored, even if it is set to a
value?

A.
When the data file of the undo tablespace is autoextensible

B.
When there are more than one undo tablespace available in the database

C.
When the undo tablespace is of a fixed size and retention guarantee is not enabled

D.
When the undo tablespace is autoextensible and retention guarantee is not enabled

Explanation:



Leave a Reply 1

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


amateur

amateur

C. For fixed- size undo tablespaces, the system automatically tunes for the maximum possible undo retention period, based on undo tablespace size and usage history, and ignores UNDO_RETENTION unless retention guarantee is enabled