Index >
ORACLE Server Parameters >
max_rollback_segments
max_rollback_segments
Oracle 11.1.0:
No such parmeter in Oracle 11.1.0.
Oracle 10.2.0:
No such parmeter in Oracle 10.2.0.
Oracle 10.1.0:
No such parmeter in Oracle 10.1.0.
Oracle 9.2.0:
Parameter 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:
Parameter 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:
Parameter 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:
Parameter 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 fullCause: 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.
|