oracle查看、处置锁定的表

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    303SELECT sid,serial# FROM v$session WHERE sid = 303; 查出sid303对应的sid，serial#为734alter system kill session '303,734';