Removing sessions where status=killed

In v$session some records are status=killed. It increses number of sessions. Say the database is working fine under 150 sessions. How do I remove the sessions where status is killed?

    Requires Free Membership to View

    Login

When an inactive session has been terminated, the STATUS of the session in the V$SESSION view is KILLED. The row for the terminated session is removed from V$SESSION after the user attempts to use the session again and receives the ORA-00028 message.

If that's not practical, you can kill the session's server process at the OS level. Use kill on Unix or Linux, or orakill on Windows.

This was first published in April 2005

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top