Locks on Object & Remove Locks

Query to Knoe locks on the object:


SELECT c.owner, c.object_name, c.object_type, b.SID, b.serial#, b.status,
       b.osuser, b.machine
  FROM v$locked_object a, v$session b, dba_objects c
 WHERE b.SID = a.session_id AND a.object_id = c.object_id;


Example :  To remove locks on object:

ALTER SYSTEM KILL SESSION 'sid,serial#';

 ALTER SYSTEM KILL SESSION '155,52745';