Oracle Error ORA-00031: session marked for kill

Oracle Error Message

ORA-00031: session marked for kill

Reason for the Error

The session defined in an ALTER SYSTEM KILL SESSION command has been marked for kill even though it cannot be terminated right now (because it is rolling back or blocked on a network operation).

This signifies that as soon as its current unabruptable operation is complete, it will be put to death.

Solution

The session can be terminated without additional action, but subsequent uses of the ALTER SYSTEM KILL SESSION command on this session could hasten its demise.