Posts

Showing posts from November, 2018

oracle lock

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