| 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 | 5 |
| Modifiable | No |
| Range of values | 1 to operating system-dependent |
| Oracle RAC | Multiple instances can have different values. |
TRANSACTIONS_PER_ROLLBACK_SEGMENT specifies the number of concurrent transactions you expect each rollback segment to have to handle. The minimum number of rollback segments acquired at startup is TRANSACTIONS divided by the value for this parameter. For example, if TRANSACTIONS is 101 and this parameter is 10, then the minimum number of rollback segments acquired would be the ratio 101/10, rounded up to 11.
You can acquire more rollback segments by naming them in the parameter ROLLBACK_SEGMENTS.
See Also:
Oracle Database Administrator's Guide for information on setting this parameter.
Oracle Real Application Clusters Administration and Deployment Guide for how Oracle acquires rollback segments.
Your operating system-specific Oracle documentation for the range of values for this parameter.
|
 Copyright © 2002, 2009, Oracle and/or its affiliates. All rights reserved. Legal Notices |
|
