Tuesday, April 10, 2012

Kill session which has KILLED status

ALTER SYSTEM KILL Session Marked for Killed Forever

Sometimes even after we killed the sessions at database level, those session might be still exist but its status could be in KILLED.

at this time use the below query to find which process to kill.

SQL> SELECT SPID FROM V$PROCESS WHERE NOT EXISTS (SELECT 1 FROM V$SESSION WHERE PADDR = ADDR);

Need to kill spid at O/S level from above query

No comments:

Post a Comment