| Oracle® Database Reference 11g Release 2 (11.2) Part Number E10820-02 |
|
|
View PDF |
| Oracle® Database Reference 11g Release 2 (11.2) Part Number E10820-02 |
|
|
View PDF |
| 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 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
|
 Copyright © 2002, 2009, Oracle and/or its affiliates. All rights reserved. Legal Notices |
|
