락걸린 세션 Kill
>>락 확인 SELECT A.SID, A.SERIAL#, A.USERNAME, A.PROCESS, B.OBJECT_NAME, DECODE(C.LMODE, 2, 'RS', 3, 'RX', 4, 'S', 5, 'SRX', 8, 'X', 'NO') TABLE_LOCK, DECODE(A.COMMAND, 2, 'INSERT',3, 'SELECT',6, 'UPDATE', 7, 'DELETE', 12, 'DROP',6, 'LOCK', 'UNKNOWN') SQL, DECODE(A.LOCKWAIT, NULL, 'NO WAIT', 'WAIT') STATUS FROM V$SESSION A, DBA_OBJECTS B, V$LOCK C WHERE A.SID = C.SID AND B.OBJECT_ID = C.ID1 AND C.T..
더보기