| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-03 |
|
|
View PDF |
| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-03 |
|
|
View PDF |
| 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 Database Oracle Clusterware and Oracle Real Application Clusters Administration and Deployment Guide for the relationship of this parameter to the number of rollback segments
