Killing a “Killed” Session in Oracle

“Killing” a session in Oracle just means that you’ve asked the session to kill itself. That can take time depending on what the session is doing.

If you have sessions with status “KILLED” that you know aren’t doing anything important, you can kill the session immediately by executing :

ALTER SYSTEM KILL SESSION ‘sid,serial#’ IMMEDIATE;

Leave a Reply