Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03 |
|
|
PDF · Mobi · ePub |
Property | Description |
---|---|
Parameter type | Integer |
Default value | Derived: (1.1 * SESSIONS ) |
Modifiable | No |
Range of values | 4 to 232 |
Oracle RAC | Multiple instances can have different values. |
TRANSACTIONS
specifies how many rollback segments to online when UNDO_MANAGEMENT
=
MANUAL
. The maximum number of concurrent transactions is now restricted by undo tablespace size (UNDO_MANAGEMENT
=
AUTO
) or the number of online rollback segments (UNDO_MANAGEMENT
=
MANUAL
).
See Also:
Oracle Database Administrator's Guide for information on setting this parameter
Oracle Real Application Clusters Administration and Deployment Guide for the relationship of this parameter to the number of rollback segments