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 -> Orphaned Row Locks

Orphaned Row Locks

From: Clifford <clifford_at_bang.com>
Date: Thu, 11 Mar 1999 15:42:14 GMT
Message-ID: <36e7e394.625188@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 - 09:42:14 CST












Original text of this message













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