turtle

SELECT B.TYPE, C.OBJECT_NAME, A.SID, A.SERIAL#    FROM  V$SESSION A, V$LOCK B, DBA_OBJECTS C    WHERE A.SID=B.SID     AND B.ID1=C.OBJECT_ID     AND B.TYPE='TM'     AND C.OBJECT_NAME='테이블명';         ALTER SYSTEM KILL SESSION '1348, 16425';

SELECT A.SID ,A.SERIAL# FROM V$SESSION A ,V$LOCK B ,DBA_OBJECTS C WHERE A.SID = B.SID AND B.TYPE = 'TM' AND C.OBJECT_NAME = UPPER('t2')  ALTER SYSTEM KILL SESSION '506,5397'