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

-- 락 걸린 테이블 확인 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 ..

2023.02.06