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