Ask the Expert

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

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

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: