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