oracle解锁

--锁表的连接
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; 

alter system kill session '140,4';