Re: Releasing Lock by other users

On Sat, 09 Jan 1999 02:28:37 GMT, robertch_at_mindspring.com (Robert Chung) wrote:

>I can find out which object in database is locked by which user by
>taking a look at v$locked_object and dba_objects views, but I do not
>know how to unlock that object. Is there any wayfor DBA to unlock
>those objects locked by other users? So far I have been just killing
>their session to unlock those objects. (oh, silly.) Thanks in
>advance.
>

Look at DBMS_LOCK utils, it has various lock processing functions including a lock release function.

Paul
aspscott_at_tcp.co.uk
^^ remove 'as' anti spam prefix to reply Received on Sat Jan 09 1999 - 06:09:11 CST