Session that has been killed hangs around
Hi,
This is probably an old issue and many may have figured out but I haven't and need your help. We have noticed that when the application sessions get hung in the Oracle server (we are running Oracle 9.0.1 on AIX 4.3.3), we kill them with ALTER SYSTEM command. The session status shows it has been KILLED but it does not vanish. Then we look for associated PID and do "ps -ef" but the process is no longer there. How we get rid of sessions that are hung and subsequently KILLED but have not gone away ? The only we have figured out to clean them up is by restarting the instance. We can't afford to restart the instance in production to handle this. Can someone let me know how to handle this ?
Thanks in advance.