Sometimes you see sessions does not wipe out immediately or you see “marked for kill” message and they stays in killed state. You can kill them using below query.

About The Author

Comments

  1. zhwsh

    I can’t. Report ORA-00026:missing or invalid session ID..
    must be run ” kill -9 spid” in os.

    select ‘kill -9 ‘||spid from v$process where addr in(select creator_addr from v$session where status=’KILLED’);

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.