日期:2014-05-16 浏览次数:20476 次
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';