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.
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.
Browse all solutions to database errors from Oracle, MS SQL or MySQL
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