Lock Fairness :-)

From: <shortcutter_at_googlemail.com>
Date: Thu, 29 Nov 2007 08:46:45 -0800 (PST)
Message-ID: <8728e04b-d116-47ff-b1a9-b150c8c6798a@e67g2000hsc.googlegroups.com>

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 Received on Thu Nov 29 2007 - 10:46:45 CST