TRANSACTIONS

Parameter type:

Integer

Parameter class:

Static

Default value:

Derived (1.1 * SESSIONS)

Range of values:

4 to 232

Oracle Parallel Server:

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.