Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Index > ORACLE Server Parameters > undo_retention

undo_retention

Oracle 11.1.0:

Parameter Name:undo_retention
Description:undo retention in seconds
Type:NUMBER Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:IMMEDIATE

Oracle 10.2.0:

Parameter Name:undo_retention
Description:undo retention in seconds
Type:NUMBER Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:IMMEDIATE

Oracle 10.1.0:

Parameter Name:undo_retention
Description:undo retention in seconds
Type:NUMBER Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:IMMEDIATE

Oracle 9.2.0:

Parameter Name:undo_retention
Description:undo retention in seconds
Type:NUMBER Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:IMMEDIATE

Oracle 8.1.7:

No such parmeter in Oracle 8.1.7.

Oracle 8.0.6:

No such parmeter in Oracle 8.0.6.

Oracle 7.3.4:

No such parmeter in Oracle 7.3.4.

Related Error Messages:

ORA-01555: snapshot too old: rollback segment number %s with name \"%s\" too small
    Cause: rollback records needed by a reader for consistent read are overwritten by other writers

    Action: If in Automatic Undo Management mode, increase undo_retention setting. Otherwise, use larger rollback segments

ORA-30026: Undo tablespace '%s' has unexpired undo with %s(sec) left, Undo_Retention=%s(sec)

    Cause: Tried to drop a tablespace that contains unexpired undo information

    Action: lower setting of UNDO_RETENTION or wait a while before reissue command to drop undo tablespace

ORA-30052: invalid lower limit snapshot expression

    Cause: The lower limit snapshot expression was below the UNDO_RETENTION limit.

    Action: Specify a valid lower limit snapshot expression.

This parameter is documented in the Oracle Server Reference Guide. Search for more info about [ undo_retention ] on the Oracle FAQ.

HOME | ASK QUESTION | ADD FAQ | SEARCH | E-MAIL US