Initialization Parameters, 44 of 188

DISTRIBUTED_TRANSACTIONS

Parameter type:	Integer
Parameter class:	Static
Default value:	Operating system dependent
Range of values:	0 to the value of the `TRANSACTIONS` parameter
`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: No distributed transactions are allowed for the database. The recovery (`RECO`) process, which resolves failures involving distributed transactions, does not start when the instance starts up. See Also: Oracle8i Distributed Database Systems for more information on setting this parameter.