오라클 락 테이블 조회, 삭제, 세션 킬

-- 락 걸린 테이블 확인
 SELECT DO.OBJECT_NAME,
                DO.OWNER,
                DO.OBJECT_TYPE,
                DO.OWNER,
                VO.XIDUSN,
                VO.SESSION_ID,
                VO.LOCKED_MODE
     FROM V$LOCKED_OBJECT VO, DBA_OBJECTS DO
   WHERE VO.OBJECT_ID = DO.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='테이블명'
;

-- 세션 킬
alter system kill session 'sid number, serial number';