[oracle] Oracle Lock 확인방법 및 세션 KILL하기

SELECT 

DISTINCT t1.session_id AS session_id

  ,t2.serial# AS serial_no

    ,t1.os_user_name AS os_user_name

    ,t1.oracle_username AS oracle_username

    ,t2.status AS status

    ,t3.object_name

    ,DECODE( locked_mode

        ,2, 'ROW SHARE'

        ,3, 'ROW EXCLUSIVE'

        ,4, 'SHARE'

        ,5, 'SHARE ROW EXCLUSIVE'

        ,6, 'EXCLUSIVE'

        ,'UNKNOWN'

    ) lock_mode

FROM v$locked_object t1, v$session t2, dba_objects t3

WHERE t1.session_id = t2.SID

AND t1.object_id = t3.object_id;

            

            

alter SYSTEM KILL SESSION '126, 9622'

            

            

            

            

SELECT * FROM  v$session