본문 바로가기

Kill

[DB] 오라클(oracle) 락(lock) 확인 및 제거(kill) 오라클(oracle) 락(lock) 확인 및 제거(kill) ====================================================================================== -- 락걸린 테이블 확인 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$.. 더보기

티스토리툴바