-
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
-
What is it set for now? I think it is safe to increase it. The only restriction is that the value of distributed_transactions cannot exceed the value of transactions.
-
But does it consume more memory? We are short of memory now.
