[예제로 배우는 오라클SQL] 세션에서 ROW LOCK 조회 및 LOCK 해제

-- 락 현황 확인

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

-- 락 해제(SID, SERIAL# 입력하면 락 해제됨)

ALTER SYSTEM KILL SESSION '626,25103'