ORA-00031 session marked for kill

Error:  ORA-00031 session marked for kill 
---------------------------------------------------------------------------
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 uninterruptable 
	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. 

--判断当前是否有回滚事务
alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
select usn,
       state,
       undoblockstotal "Total",
       undoblocksdone "Done",
       undoblockstotal - undoblocksdone "ToDo",
       decode(cputime,
              0,
              'unknown',
              sysdate + (((undoblockstotal - undoblocksdone) /
              (undoblocksdone / cputime)) / 86400)) "Estimated time to complete"
  from v$fast_start_transactions
  where state = 'RECOVERING';

-- 执行以下SQL，需要DBA的权限

--1.通过sid查询SPID
select spid from v$process where addr in (select paddr from v$session where sid=1323);

--2.查询条件 KILLED ，必须大写
SELECT P.SPID, S.SID, S.SERIAL#, S.USERNAME, S.PROGRAM
FROM V$PROCESS P, V$SESSION S
WHERE P.ADDR=S.PADDR AND S.STATUS='KILLED';

## $SPID 为 第1步的sql查出的SPID

kill –9 $SPID

## $SPID 为 第1步的sql查出的SPID

##name为数据库实例名
select instance_name from gv$instance;

##cmd命令行执行
orakill 数据库实例名 $SPID