Re: Oracle detects deadlock (ORA-00060) with just one session open

From: omlet4 <notrolls_at_notrolls.omlet.org.notrolls>
Date: Tue, 07 Sep 2004 06:39:21 -0400
Message-ID: <639afafa8e2fd034d586a6ce484f46b4@localhost.talkaboutdatabases.com>

Andre,

Thank you for your kind e-mail; you may download OMLET from http://www.omlet.org/download.html - let me know if you have any problems.

Now the problem you have is with the ksl module: which is responsible for locking services: including latches and wait/post.

kslpsr enforces latch hirearchy to prevent deadlocks and generally enforces ordering and that only one latch at a time is allowed to have 2 children held.

hope this helps!

-Amjad
news.omlet.org
24x7 frontline news
we never shutup! Received on Tue Sep 07 2004 - 05:39:21 CDT