Re: Locks on multi-user systems
Date: Tue, 22 Jan 2002 21:20:50 +0000 (UTC)
Message-ID: <a2kl3i$rnd$1_at_geraldo.cc.utexas.edu>
Martin Drautzburg <drautzburg_at_altavista.net> wrote:
: What is the best strategy to avoid the situation, where one user is
: blocked by another user ? The first user will only notice that the
: system hangs and does not know, when things will continue, nor who the
: blocking user is.
??
Resource ordering. Read the Dining Philosophers Problem.
: I found a posting somewhere, where the suggestion was made to always
: work thru a database link (again Oracle). This will turn all
: transactions into distributed transactions and there is a distributed
: lock timeout on oracle. But there is no general lock timeout AKAIK.
Big win with Oracle is the versioned locking system. But you should still read the above and start to learn the general theory to avoid deadlocks.
: Any ideas would be greatly appreciated.
HTH. Received on Tue Jan 22 2002 - 22:20:50 CET