Ghost or zombie Processes

I am asking your help in solving a GPSM (Oracle 7 Database) problem. It seems that we are seeing an increase in the number of Application server ghost sessions. These sessions are the result of users powering off or re-booting their computers without properly exiting from the GPSM (ORACLE 7 Via SLQNET V1 (Latest Version)) clinet-server application.

A ghost session will take on the characteristics of a looping program and secure a large amount of the CPUUs performance. When this happens the performance of other users suffer drastically. At this time, the only way to get rid of these ghost session is to call you and have you manually delete this looping program. I am asking, if you know of any Utility, third party application, or an HP program that will automatically scan for these ghost sessions and if found, delete them.

regards,
John Hawkins
615-734-4468 phone
615-734-4771 fax
Please Reply by e-mail or posting or phone call or fax thanks for the help!
P.S. I wrote a shell script which runs from cron that checks the CPU utilization from ps -ef | grep oracle | grep sid etc... if the CPU is above say 500 I kill -9 the process. I'm not real comfortable with this though. Theres got to be a better way. Received on Sat Apr 01 1995 - 00:00:00 CEST