Which statement is true about the UNDO_RETENTION parameter when retention guarantee is not enabled?

Question

Options

• AIt is the time period after which the undo data becomes obsolete.
• BIt is the time period after which the committed undo data would be transferred to a temporary tablespace.
• CIt is the minimum time period up to which the committed undo data would be retained if free undo
• DIt is the time period after which the undo data is transferred to the Flash Recovery Area to provide

• A
  10% (3)
• B
  3% (1)
• C
  84% (26)
• D
  3% (1)

Explanation

UNDO_RETENTION specifies (in seconds) how long Oracle tries to retain committed undo data so that long-running queries can use it for read consistency. When retention guarantee is NOT enabled (the default), Oracle treats this as a best-effort target: it will retain committed undo for at least this duration if free undo space is available, but it is allowed to overwrite unexpired undo if the undo tablespace runs out of space and needs room for new transactions. Option A is wrong because the parameter is not a hard expiry after which undo becomes obsolete. Option B is wrong because undo is never moved to a temporary tablespace. Option D is wrong because undo is not transferred to the Flash Recovery Area.

No community discussion yet for this question.