We are having problems with distributed transactions, receiving a message that there are too many distributed transactions resulting in a failure.

One idea is to single thread the distributed transactions. They are driven by one process. This could be done in the Perl scripts that control them.

Another idea is to increase the distributed_transactions initialization parameter. But I don't know the impact of doing this in terms of memory consumption or other resource consumption.

Does anyone know the "cost" or impact of increasing this parameter?

TIA