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';
oracle查看、处理锁定的表
最新推荐文章于 2022-07-10 12:18:55 发布