查看和清除数据库锁对象

在日常开发中，共同用同一个数据库进行开发，是一件很平常的事，但有时候就发现某些表被某用户某连接占用了，锁住了，能够快速知道是某个用户占用了，可以用以下SQL语句进行查询。
--查看锁表的连接
select t2.*
  from v$locked_object t1, v$session t2
 where t1.session_id = t2.sid
 order by t2.logon_time;

--查看被锁的表对象
select t3.name, t2.*
  from v$locked_object t1, v$session t2, sys.obj$ t3
 where t1.session_id = t2.sid
   and t1.OBJECT_ID = t3.obj#
 order by t2.logon_time;

--查看被锁的表对象
select t2.SID, t2.SERIAL#, t2.MACHINE, t3.*
  from v$locked_object t1, v$session t2, sys.obj$ t3
 where t1.session_id = t2.sid
   and t1.OBJECT_ID = t3.obj#
 order by t2.logon_time;

--锁对象
select t1.*
  from v$locked_object t1, v$session t2
 where t1.session_id = t2.sid
 order by t2.logon_time;

--KILL对方连接
alter system kill session '140,4';