1.342 TRANSACTIONS

TRANSACTIONS specifies how many rollback segments to online when UNDO_MANAGEMENT = MANUAL.

Property Description

Parameter type

Integer

Default value

Derived: (1.1 * SESSIONS)

Modifiable

No

Modifiable in a PDB

No

Range of values

4 to 232

Basic

No

Oracle RAC

Multiple instances can have different values.

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).