Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Orphaned Row Locks
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