deadlock detection

From: Ryan <ryan.gaffuri_at_cox.net>
Date: Thu, 1 Apr 2004 22:45:29 -0500
Message-ID: <516701c41864$f1a49d70$51a36244@ryan2le36ofjce>

How does oracle detect deadlocks? Here is my best guess. Oracle's lock manager tracks locks at the object level, but not at the row level. transaction A locks row 1 in table A
transaction B locks row 1 in table B

Transaction A attempts to lock row 1 in table B, but is forced to wait. Transaction B attempts to lock row 1 in table A, but is forced to wait.

The oracle lock manager notes that this at the object level. So it is possible that this is a deadlock. The lock manager then checks the transaction table for the row that is locked in each table and from that can determine whether this is a deadlock condition.

Am I correct?

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Thu Apr 01 2004 - 21:41:27 CST