oracle 락 확인

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

죽이기 

alter system kill session 'sid, session';

테이블 확인

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;

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

http://sarang.tistory.com/186