Re: Removing lock on a record

Jacques Desmazieres wrote:
>
> Hi,
>
> While running an application on a client, this application failed after
> creating a lock (SELECT FOR UPDATE NOWAIT) on a record. How do I remove this
> lock?
>
> I can see the lock in the V$LOCKED_OBJECT & V$LOCK virtual tables
>
> Thanks
>
> Jacques

Oracle will eventually clean up the failed session, but you if you know the sid,serial#, you can issue a 'alter system kill session' to speed things up a little.

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse