13 Replies Latest reply on Jul 29, 2016 4:54 PM by jgarry

    How to remove KILLED session

    Miroslav Dunik

      Dear friends.

      I have a problem with strange sessions in Oracle DB.

      The session has status "KILLED" for more than 24 hours, so obviously PMON is not performing cleanup.

       

      Strange thing no.1:
      command ALTER SYSTEM KILL SESSION 'xx,xxxx' IMMEDIATE; is NOT throwing an error about session already marked to kill, it says "System altered" over and over again

       

      Strange thing no.2:

      There is no process with ADDR for this session in V$PROCESS, therefore I have nothing to kill on the OS level.

       

      What can I do in this situation about the session?

       

      Version: Oracle DB 11.2.0.3.0 64bit for Windows