| 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