Re: Lock Fairness :-)

From: <fitzjarrell_at_cox.net>
Date: Thu, 29 Nov 2007 08:49:53 -0800 (PST)
Message-ID: <97a84a15-4d5d-48ef-9c89-f506df88164a@e1g2000hsh.googlegroups.com>

On Nov 29, 10:46 am, "shortcut..._at_googlemail.com" <shortcut..._at_googlemail.com> wrote:
> Hi,
>
> while investigating an ORA-02049 (time-out: distributed transaction
> waiting for lock) I was asked which of the TX waiting for a lock will
> obtain the lock after it is released. I tried Concepts Guide,
> Administrator Guide, searched Oracle docs and Google but could not
> find anything meaningful on Oracle's lock fairness. I would assume
> that it's simply unspecified. Does anyone have more specific
> information about this? In practice it's certainly safe to assume
> nothing about the order TX's are served but I am curious... :-)
>
> Kind regards
>
> robert

Usually the first one in the queue.

David Fitzjarrell Received on Thu Nov 29 2007 - 10:49:53 CST