查询oracle表是否被锁并如何解锁

（1）查看那些表被锁

select b.username,c.object_name table_name , b.sid, b.serial#, logon_time
  from v$locked_object a, v$session b,dba_objects c
 where a.session_id = b.sid and a.object_id=c.object_id
 order by b.logon_time;

（2）杀掉对应进程

执行命令：

alter system kill session '451,5695';

其中451为sid,5695为serial#