Re: Lock Fairness

On 29.11.2007 17:49, fitzjarrell_at_cox.net wrote: > On Nov 29, 10:46 am, "shortcut..._at_googlemail.com" > <shortcut..._at_googlemail.com> wrote:

>> 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... :-)
>
> Usually the first one in the queue.

Thank you, David! Sounds as if you knew something about exceptional cases where it is not the first one. :-) I could only speculate here (e.g. a TX waiting for more taken locks at the same time could be left waiting if another one can continue immediately). Do you have a pointer to further material on the matter?

Kind regards

        robert Received on Thu Nov 29 2007 - 11:58:40 CST