Oracle Lock 확인
--락걸린 테이블 확인SELECT do.object_name, do.owner, do.object_type, do.owner, vo.xidusn, vo.session_id, vo.locked_modeFROM v$locked_object vo , dba_objects doWHERE vo.object_id = do.object_id ; --해당테이블이 락에 걸렸는지.. SELECT A.SID, A.SERIAL#, B.TYPE, C.OBJECT_NAMEFROM V$SESSION A, V$LOCK B, DBA_OBJECTS CWHERE A.SID=B.SID AND B.ID1=C.OBJECT_ID AND B.TYPE='TM' AND C.OBJECT_NAM..
DataBase/Oracle
2012. 8. 11. 18:29