Problem solve
Get help with specific problems with your technologies, process and projects.
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?
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.
