오라클 LOCK 확인

---

SELECT DISTINCT SS.PREV_EXEC_START
              , LO.SESSION_ID
              , SS.SERIAL#
              , D0.OBJECT_NAME
              , SS.MACHINE
              , SS.PROGRAM
              , ST.ADDRESS
              , ST.PIECE
              , ST.SQL_TEXT
           FROM V$LOCKED_OBJECT LO
              , V$SESSION SS
              , DBA_OBJECTS D0
              , V$SQLTEXT ST
          WHERE LO.SESSION_ID = SS.SID
            AND LO.OBJECT_ID = D0.OBJECT_ID
            AND SS.SQL_ADDRESS = ST.ADDRESS
       ORDER BY SS.PREV_EXEC_START
              , LO.SESSION_ID
              , SS.SERIAL#
              , ST.PIECE;

---

 

-- ALTER SYSTEM KILL SESSION '1227,6264';