Session Marked for Killed Forever

You have issued below command by it seems session doesn't go away:

SQL> alter system kill session 'sid, serial#';

SQL> select status, username from v$session;

                       status killed
                        username testuser

You have issued this several times and it seems it still is marked as killed.

To overcome this needs to kill from OS level, Below is command to find OS process ID:

SQL> select p.spid,s.username,s.process from v$process p, v$session s where p.addr=s.paddr and s.sid={sid};

% kill -9 {spid}

No comments:

Post a Comment