Name

MAX_ROLLBACK_SEGMENTS

Synopsis

Value: 2-65535 Default: MAX (30, TRANSACTION / TRANSACTIONS_PER_ROLLBACK_SEGMENT)

Specifies the maximum size of the rollback segment cache in the SGA, which also signifies the maximum number of rollback segments that can be kept online simultaneously by one instance.

Get Oracle in a Nutshell now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.