session marked for kill

Solution ID:ORA-00031

Type: Oracle

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.

Actions

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.

Try the following links for this error:


http://docs.oracle.com/cd/E16655_01/server.121/e26079/e0.htm


http://docs.oracle.com/cd/E16655_01/rac.121/e17887/admin.htm


https://community.oracle.com/message/3637866


https://community.oracle.com/message/11300693


https://community.oracle.com/message/2745680


https://community.oracle.com/message/1980882


https://community.oracle.com/message/154706


https://community.oracle.com/message/1591040


https://community.oracle.com/message/2514142


https://community.oracle.com/message/11327522


https://community.oracle.com/message/1584612


https://community.oracle.com/message/1704052


https://community.oracle.com/message/1519584


https://community.oracle.com/message/10350334


https://community.oracle.com/message/10387939


https://community.oracle.com/message/9933623


https://community.oracle.com/message/2586659


Browse all solutions to database errors from Oracle, MS SQL, or MySQL