오라클 락걸리 테이블 조회 및 락 테이블 삭제 쿼리

SELECT 
    /*+ RULE */ 
    S.USERNAME ORA_USER, 
    OSUSER OS_USER, 
    S.SID SID , 
    S.SERIAL# SERIAL#, 
    P.SPID, 
    L.TYPE TYPE, 
    DECODE(LMODE,1,'NONE',2,'RS',3,'RX',4,'S',5,'RSX',6,'X') HELD, 
    O.NAME OBJECT_NAME, 
    ID1 OBJECT_ID, 
    S.STATUS STATUS, 
    DECODE(REQUEST,1,'NONE',2,'RS',3,'RX',4,'S',5,'RSX',6,'X') REQ, 
    S.TERMINAL 
FROM V$LOCK L, 
    V$SESSION S, 
    SYS.OBJ$ O , 
    V$PROCESS P 
    WHERE L.SID = S.SID 
    AND S.PADDR=P.ADDR 
    AND L.ID1 = O.OBJ#(+) 
    AND S.USERNAME IS NOT NULL 
ORDER BY SID;

-- 세션 강제 종료
ALTER SYSTEM KILL SESSION 'SID, SPID';

예)
ALTER SYSTEM KILL SESSION '416, 15499';