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';