Oracle/MySQL 관련 게시판

Oracle/MySQL 관련 게시판

2014/08/20(13:24) from 210.93.7.51
작성자 : 주인장	조회수 : 2802 , 줄수 : 26

[Oracle] table lock session kill

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

@ 사용법 2개 인자 줌

SESSION_ID, SERIAL_NO

SQL> alter system kill session '1400,67';