View Oracle Lock Table command __oracle

See what locks the database has

Select Sess.sid,
sess.serial#,
Lo.oracle_username,
Lo.os_user_name,
Ao.object_name,
Lo.locked_mode
From V$locked_object Lo,
Dba_objects AO,
V$session Sess
where ao.object_id = lo.object_id and lo.session_id = Sess.sid;

SELECT * from V$session T1, v$locked_object t2 where t1.sid = t2. session_id;

View specific SQL statements based on SIDS

Select Sql_text from v$session a,v$sqltext_with_newlines b
where DECODE (a.sql_hash_value, 0, Prev_hash_value, sql_hash_value) =b.hash_value
and a.sid= #149 order by piece;

Kill lock Table Transaction

Alter system kill session ' 129,303′;

Reference article: http://www.anbob.com/?p=16