| Property | Description |
|---|---|
| Parameter type | Integer |
| Default value | Derived: (1.1 * SESSIONS) |
| Modifiable | No |
| Range of values | 4 to 232 |
| Real Application Clusters | Multiple instances can have different values. |
TRANSACTIONS specifies the maximum number of concurrent transactions. Greater values increase the size of the SGA and can increase the number of rollback segments allocated. The default value is greater than SESSIONS (and, in turn, PROCESSES) to allow for recursive transactions.
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