Oracle9i Database Reference Release 1 (9.0.1) Part Number A90190-02 |
|
Initialization Parameters, 52 of 220
Parameter type |
Integer |
Default value |
.25 * |
Parameter class |
Static |
Range of values |
0 to the value of the |
DISTRIBUTED_TRANSACTIONS
is relevant only if you are using Oracle's Distributed Systems feature. It specifies the maximum number of distributed transactions in which this database can participate at one time. The value of this parameter cannot exceed the value of the parameter TRANSACTIONS
.
If network failures occur at an abnormally high rate, causing many in-doubt transactions, you can decrease this parameter's value temporarily. Doing so limits the number of concurrent distributed transactions, which then reduces the number of in-doubt transactions. The reduction of in-doubt transactions, in turn, reduces the amount of blocked data and possible heuristic decision making.
If you set DISTRIBUTED_TRANSACTIONS
to 0
:
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|