주식회사 누리아이티

정보자산의 보안강화를 위한 다계층 인증SW (BaroPAM) 전문기업.

▶ Tuxedo/오류 메시지(Oracle)

Killing sessions in UNIX

누리아이티 2017. 12. 21. 08:13

SELECT VS.SID, VS.USERNAME, VS.OSUSER, VS.PROCESS FG_PID, VP.SPID BG_PID FROM V$SESSION VS, V$PROCESS VP WHERE VS.PADDR = VP.ADDR;


SID  USERNAME        OSUSER     FG_PID    BG_PID
---- --------------- ---------- --------- ---------
14   QZBHS1          QZBHS1     2924:3744 1948
29   QZBHS1          QZBHS1     3632:3844 15452
51   QZBHS1          QZBHS1     4644:3892 5438


Issued in unix (as the oracle unix user, the user thats owns the database) :

kill -9 1948
kill -9 15452
kill -9 5438