Re: Orphaned Row Locks

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 11 Mar 1999 19:46:50 -0000
Message-ID: <921180006.9260.0.nnrp-13.9e984b29@news.demon.co.uk>

Actually Oracle Corp is rather proud of the fact that the database will detect deadlocks automatically.

In an every time of 1.5 seconds.

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Chad Edwards wrote in message ...
>Don't know about "orphans", but I do know that if you have a deadlock..ie
>2 locks that are waiting on the other before they will release...the only
>way to fix it is to shutdown your database and restart it.
Received on Thu Mar 11 1999 - 13:46:50 CST