3 Replies Latest reply on May 28, 2014 12:15 PM by Anirban Mondal

    SQL Error: ORA-00031: session marked for kill


      Hi Everyone,

      My DB version is



      Oracle Database 10g Enterprise Edition Release - 64bi

      PL/SQL Release - Production                          

      CORE Production                                        

      TNS for Linux: Version - Production                  

      NLSRTL Version - Production                          

      If this error message will show up, then is there any other way to kill the session immediately. It has been locked by rollback process. Please suggest something.

      The exact error message is mentioned below.

      Error starting at line 13 in command:


      Error report:

      SQL Error: ORA-00031: session marked for kill

      00031. 00000 -  "session marked for kill"

      *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.

      *Action:   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.