Oracle锁表、解锁、批量解锁表

1、查询被锁表的SQL:

select object_name,machine,s.sid,s.serial#

from v$locked_object l,dba_objects o ,v$session s

where l.object_id　=　o.object_id and l.session_id=s.sid;

2、查看哪个进程锁的

SELECT sid, serial#, username, status, osuser FROM v$session  where serial# = '11016'

3、杀掉这个进程 

alter system kill session '52,35022'; （SID，serial#）

4、批量杀死进程

declare cursor mycur is  
select b.sid,b.serial#  
　　from v$locked_object a,v$session b  
　　where a.session_id = b.sid group by b.sid,b.serial#;  
  
begin  
  for cur in mycur  
    loop    
     execute immediate ( 'alter system  kill session  '''||cur.sid || ','|| cur.SERIAL# ||''' ');  
     end loop;  
end;