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';

cs


죽이기 


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





- 오라클 디비 죽이고 살리기 참고 사이트