ORA-00031: session marked for kill

ALTER SYSTEM KILL SESSION '230,51877' IMMEDIATE

*

ERROR at line 1:

ORA-00031: session marked for kill

SQL>  select spid from v$process where addr = (select paddr from v$session where sid=230 and serial#=51877);

SPID

------------------------

8186

SQL> !

[oracle@fihprx14:/home/oracle]#

#-> kill -9 8186

[oracle@fihprx14:/home/oracle]#

#-> ps -ef|grep 8186

  oracle  8186     1  0  Oct 21  ?         0:19 oracleptdtpi (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

  oracle 11457 11439  1 18:14:45 pts/2     0:00 grep 8186

Cause:  The session specified in an ALTER SYSTEM KILL SESSION command cannot be killed immediately (because it is rolling back or blocked on a network operation), but it has been marked for kill. This means it will be killed as soon as possible after its current uninterrupted operation is done. 

Action: No action is required for the session to be killed, but further executions of the ALTER SYSTEM KILL SESSION command on this session may cause the session to be killed sooner. 

The ORA-00031 message is returned because some activity must be completed before the session can be terminated.