Copy of Oracle FAQ ORACLE RECOVERY without DUL
ORAFAQ HOME | ORAFAQ ASK QUESTION | ORAFAQ ADD INFO | ORAFAQ SEARCH | ORAFAQ E-MAIL
 

Index > ORACLE Server Parameters > max_rollback_segments

max_rollback_segments


Oracle 10.0.1:

No such parmeter in Oracle 10.0.1.

Oracle 9.2.0:

Paramter Name:max_rollback_segments
Description:max. number of rollback segments in SGA cache
Type:NUMBER Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:FALSE

Oracle 8.1.7:

Paramter Name:max_rollback_segments
Description:max. number of rollback segments in SGA cache
Type:NUMBER Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:FALSE

Oracle 8.0.6:

Paramter Name:max_rollback_segments
Description:max. number of rollback segments in SGA cache
Type:NUMBER Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:FALSE

Oracle 7.3.4:

Paramter Name:max_rollback_segments
Description:max. number of rollback segments in SGA cache
Type:NUMBER Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:FALSE

Related Error Messages:

ORA-01599: failed to acquire rollback segment (%s), cache space is full
    Cause: the amount statically allocated is not enough based on max_rollback_segments parameter.

    Action: For now take another rollback segment offline or increase the parameter max_rollback_segments


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

ORAFAQ HOME | ORAFAQ ASK QUESTION | ORAFAQ ADD FAQ | ORAFAQ SEARCH | ORAFAQ E-MAIL
All content of this page is copy from www.orafaq.com