ORA-00031: session marked for kill
The session trying to issue the kill will hang for 60 seconds and then return this “session marked for kill” message. And the target session does not get killed at all.
FROM v$session a, v$transaction b
WHERE a.saddr = b.ses_addr and a.sid=&sid; –>>> Enter the blocking session SID here (&sid:).
from v$process a , v$session b
where a.addr=b.paddr and b.sid=&sid;
For more information refer MOS DOC Id: Kill A Process – Not able to clear session (Doc ID 1493261.1)
Thanks for reading ..