Tag Info

New answers tagged

0

It's not necessarily the number of transactions, but the timeout. The parameter distrubuted_lock_timeout is set to 60 seconds by default. The purpose of this parameter is to avoid having distributed transactions in a long running wait status while something else is performing work on that row; the transaction will wait 60 seconds, then Oracle kills it. You ...


0

Yes! There is a wait queue and the first requester is the first served. Beware of deadlocks...



Top 50 recent answers are included