Oracle Lock 확인 및 해제
>>락 확인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') STATUSFROM V$SESSION A, DBA_OBJECTS B, V$LOCK CWHERE A.SID = C.SIDAND B.OBJECT_ID = C.ID..
DataBase/Oracle
2014. 4. 1. 15:29