oracle查看锁表及解锁

SELECT OBJECT_NAME,
       MACHINE,
       S.SID,
       S.SERIAL#
FROM V$LOCKED_OBJECT L,
     DBA_OBJECTS O,
     V$SESSION S
WHERE L.OBJECT_ID　 = 　O.OBJECT_ID
AND   L.SESSION_ID = S.SID;

ALTER SYSTEM KILL SESSION 'SID,SERIAL#';