HOW TO RESOLVE ORA-00031: session marked for kill

ERROR:

 ERROR: ORA-00031: session marked for kill

SOLUTION: 

Note: You may find out thread id for session kil actvity from Operating Sysyem (Linux OS)

select ab.sid, ab.username, ab.osuser, ab.process fg_pid,

cd.spid bg_pid from v$session ab, v$process cd

where ab.paddr = cd.addr;

(OR)

If you know the system user name (OS Naming Unser) you may easily find out SPID.

select ab.sid,ab.username,ab.osuser, ab.process,cd.spid

from v$session ab, v$process cd where ab.paddr = cd.addr

and ab.username=upper('&schema')

and ab.osuser='&system_hostname';

SID    USERNAME    OSUSER        PROCESS   SPID

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

99    FURQAN    furqan-hafeez   2194:2565 274438

[furqan@furqan-hafeez ~]$ ps -ef |grep 274438

[furqan@furqan-hafeez ~]$ kill -9 274438