sql
oracle 락 확인
개몽구리
2019. 1. 23. 13:29
ORACLE 락 확인
1 2 3 4 5 6 7 8 9 10 | SELECT a.sid, a.serial#, a.username, a.process, b.object_name, DECODE(c.lmode,2,'RS',3,'RX',4,'S',5,'SRX',8,'X','NO') "TABLE LOCK", DECODE(a.command,2,'INSERT',3,'SELECT',6,'UPDATE',7,'DELETE',12 ,'DROP TABLE',26,'LOCK TABLE','UNknown') "SQL", DECODE(a.lockwait, NULL,'NO wait','Wait') "STATUS" FROM v$session a, dba_objects b, v$lock c WHERE a.sid=c.sid and b.object_id=c.id1 AND c.type='TM'; |
죽이기
1 | alter system kill session 'sid, session'; | cs |
테이블 확인
1 2 3 4 | 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; | cs |
- 오라클 디비 죽이고 살리기 참고 사이트