oracle 表解锁

单表解锁：

SELECT  lpad(' ',decode(l.xidusn ,0,3,0))||l.oracle_username User_name,o.owner,o.object_name,o.object_type,s.sid,s.serial#FROM v$locked_object l,dba_objects o,v$session sWHERE l.object_id=o.object_idAND l.session_id=s.sidORDER BY o.object_id,xidusn DESC; --alter system kill session 'sid, serial#'alter system kill session  '678, 51385';alter system kill session  '586, 60893';

批量解锁：

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;