日期:2014-05-16  浏览次数:20476 次

oracle查看、处理锁定的表
SELECT /*+ rule*/ 
a.sid, b.owner, object_name, object_type 
FROM v$lock a, all_objects b 
WHERE TYPE = 'TM' 
and a.id1 = b.object_id; 

查出4个sid:284    294     294    303

SELECT sid,serial# FROM v$session WHERE sid = 303; 

查出sid303对应的sid,serial#为734

alter system kill session '303,734';