Process죽이기...

$>sqlplus '/as sysdba'

SQL> oradebug setospid 21629
Oracle pid: 19, Unix process pid: 21629, image: oracle@pops (TNS V1-V3)
SQL> oradebug suspend
Statement processed.

SELECT /*+ CHOOSE */
S.SERIAL# "Serial#",
p.spid, p.pid, si.sid, s.audsid
FROM V$SESSION S, V$PROCESS P, sys.V_$SESS_IO si
WHERE S.paddr = P.addr(+)
and si.sid(+)=s.sid
AND (s.username IS NOT NULL) AND (NVL (s.osuser, 'x') <> 'SYSTEM') AND (s.TYPE <> 'BACKGROUND');

--세션 죽이기
--형식: alter system kill session 'sid, serial#'
alter system kill session '165, 34399' ;