Skip Headers

Oracle9i Database Reference
Release 2 (9.2)

Part Number A96536-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page Go to next page
View PDF

MAX_ROLLBACK_SEGMENTS

Parameter type

Integer

Default value

MAX(30, TRANSACTIONS/TRANSACTIONS_PER_ROLLBACK_SEGMENT)

Parameter class

Static

Range of values

2 to 65535

MAX_ROLLBACK_SEGMENTS specifies the maximum size of the rollback segment cache in the SGA. The number specified signifies the maximum number of rollback segments that can be kept online (that is, status of ONLINE) simultaneously by one instance.

See Also:

Oracle9i Database Administrator's Guide for more information on setting this parameter