oracle死锁表处理

锁进程
查看被锁的表

select b.owner,b.object_name,a.session_id,a.locked_mode from v$locked_object a,dba_objects b where b.object_id = a.object_id;

查看锁进程

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 '68,7129';

批量杀死死锁进程

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;
/