RDS - SESSION KILL

 

RDS 세션 킬을 할때는, RDS 유틸을 이용해야함

-- 1. STATUS 체크
SELECT A.SID
     , A.SERIAL#
     , A.STATUS
  FROM V$SESSION A
     , V$LOCK B
     , DBA_OBJECTS C
 WHERE A.SID         = B.SID
   AND B.ID1         = C.OBJECT_ID
   AND B.TYPE        = 'TM'
   AND C.OBJECT_NAME = 'TB_ORDER_DETAIL' -- 테이블명
;

-- 2. kill
BEGIN
    RDSADMIN.RDSADMIN_UTIL.KILL(
        SID    => 808, 
        SERIAL => 25827);
END;
/

-- 3. disconnect
BEGIN
    RDSADMIN.RDSADMIN_UTIL.DISCONNECT(
        SID    => 808, 
        SERIAL => 25827);
END;
/