Name

ROLLBACK_SEGMENTS

Synopsis

Values:Rollback segment names

Default:NULL

Multiple Instances:Must have different values; different instances cannot specify the same rollback segment.

Specifies one or more rollback segments to allocate by name to this instance. If this parameter is set, an instance acquires all of the rollback segments named in this parameter, even if the number of rollback segments exceeds the minimum number required by the instance (calculated from the ratio TRANSACTIONS / TRANSACTIONS_PER_ROLLBACK_SEGMENT). Although this parameter usually specifies private rollback segments, it can also specify public rollback segments if not already in use. If this parameter is not set, the instance uses all public rollback segments as the default. This parameter has the following syntax:

ROLLBACK_SEGMENTS = (rbseg _name [, rbseg _name  ] ... )

Warning

Never name the SYSTEM rollback segment as a value for the ROLLBACK_SEGMENTS parameter.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset