Oracle Commands for Locks

--Query row lock statement

Select Sql_text from V$sql a,v$session bwhere a.sql_id=b.sql_id and b.event= ' enq:tx-row lock contention ';

--Find the table that is locked

SELECT object_name, Machine, S.sid, S.serial#from gv$locked_object l, dba_objects o, gv$session swhere l.object_id = o.obj Ect_idand l.session_id = S.sid;

--Unlock

Select     s.sid,s.machine,o.object_name,l.oracle_username,l.locked_mode,       ' ALTER     SYSTEM     KILL     ' SESSION "     | | s.sid| | ', ' | | s.serial#| | '; ' Command       from     v$locked_object     l,v$session     s,all_objects     o       where     l.session_id= S.sid     and     l.object_id=o.object_id;  

Oracle Commands for Locks