Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: deadlock detection
Oracle reads a book about graph theory, especially the chapter
about cyclical graphs and uses the algorithm described there.
I happen to know of a former VP at the Oracle Corp. who is very
well versed in math and who wrote a book about tuning Oracle and
threw in some queuing theory, which was really refreshing, indeed.
It is conceivable that this guy might have heard about the graph theory
and linear algebra and implemented something of that nature to resolve
deadlocks.
to detect graphs.
On 04/01/2004 10:45:29 PM, Ryan wrote:
> 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.
-- Mladen Gogala Oracle DBA ---------------------------------------------------------------- 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:51:34 CST