oracle 表解锁

最新推荐文章于 2025-08-14 17:25:02 发布

原创最新推荐文章于 2025-08-14 17:25:02 发布 · 294 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#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 s
WHERE l.object_id=o.object_id
AND l.session_id=s.sid
ORDER 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;