Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Orphaned Row Locks

Re: Orphaned Row Locks

From: Mladen Gogala <mgogala_at_yahoo.com>
Date: Thu, 11 Mar 1999 21:59:05 GMT
Message-ID: <7c9eb3$qdn$1@nnrp1.dejanews.com>


In article <36e7e394.625188_at_news.dial.pipex.com>,   clifford_at_bang.com (Clifford) 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?
>

A) Crashes on NT are not unusual, but I don't know much about NT. On Unix, you would install signal handler for, say, SIGSEGV and call ologof in that handler.
Mladen Gogala

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Mar 11 1999 - 15:59:05 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US