【oracle】查看被锁表及解锁表

--查询被锁的表

select a.object_name,
       b.session_id,
       c.serial#,
       c.program,
       c.username,
       c.command,
       c.machine,
       c.lockwait
  from all_objects a, v$locked_object b, v$session c
 where a.object_id = b.object_id
   and c.sid = b.session_id;

--查看是哪个session引起的

 
select b.username, b.sid, b.serial#, logon_time
  from v$locked_object a, v$session b
 where a.session_id = b.sid
 order by b.logon_time;

--杀掉对应进程即解锁

alter system kill session '432,7303' --其中432是sid 7303是serial