Re: deadlock detection
- From: Mladen Gogala <mgogala@xxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 1 Apr 2004 22:53:47 -0500
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
