DISTRIBUTED_TRANSACTIONS

Parameter type	Integer
Default value	.25 * TRANSACTIONS
Parameter class	Static
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: Oracle9i Database Administrator's Guide for more information on setting this parameter