*** 락 테이블 조회 ***
SELECT
B.OBJECT_NAME, B.OWNER, B.OBJECT_TYPE, A.XIDUSN, A.SESSION_ID, A.LOCKED_MODE
FROM
V$LOCKED_OBJECT A, DBA_OBJECTS B
WHERE A.OBJECT_ID = B.OBJECT_ID
;
*** 특정 테이블 락 여부 확인 ***
SELECT
A.SID, A.SERIAL#, B.TYPE, C.OBJECT_NAME
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 = '테이블명'
;
