Re: Orphaned Row Locks

From: Mark Gumbs <mgumbs_at_hotmail.com>
Date: Thu, 11 Mar 1999 16:48:27 -0000
Message-ID: <36e7f29c.0@145.227.194.253>

I had this problem in my last job. Worse still, killing via v$session did not remove the rotten locks. Phoned oracle who couldn't suggest anything else so i had to shutdown and startup the database.

If there is another solution around, i'll be interested too.

Mark

Clifford wrote in message <36e7e394.625188_at_news.dial.pipex.com>...
>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?
Received on Thu Mar 11 1999 - 10:48:27 CST