Re: Orphaned Row Locks

From: Chad Edwards <cedwards_at_infinet.com>
Date: Thu, 11 Mar 1999 18:05:08 GMT
Message-ID: <oBTF2.1800$f2.2368@news2>

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.

According to docs I've read, the best way to keep this from happening is to have your DBA keep a close eye on the locks that are happening.

Chad

Clifford <clifford_at_bang.com> wrote:
: Oracle Version : 7.3
: I have an app that locks rows for updating. Now when this app crashes
: (NT) these locks are still held by oracle so that no-one can update
: said rows until the instances are killed via v$session/Instance
: manager.

: How do i ensure that the row locks are released when the app crashes.

: Thanks :-)

: Cliff
: Which is more important :
: The Country or it's populace?

Official home of RMBL! http://surf.to/rmbl E-mail Don Ferry (DONFERRY_at_PRODIGY.NET) to be put on the waiting list. Owner/GM/Manager of the Columbus Capitals

Received on Thu Mar 11 1999 - 12:05:08 CST