PLEASE Help Me Kill Them (process not dying)

Hello,

Oracle 7.3.4.0.0
HP-UX 10.20

We have an application (Baan IVc) that spawns a process (Vertex Application tax software) and fails to close the process when it is through. I have created a profile that will SNIP the process if it is idle more than 60 minutes and have assigned it to the user (VERTEX) who creates the process.

My question is this: How can I remove the DEAD processes? All of these process belong to VERTEX. Does anyone have a script that will remove these processes based on status (killed, sniped, etc) and user?

Here's a sample after doing the following SQL: select a.username, a.spid, b.username, b.osuser from v$process a, v$session b where b.paddr=a.addr;

oracle          24084     VERTEX                         laird         
oracle          23950     VERTEX                         zarragak      
oracle          23952     VERTEX                         zarragak      
oracle          24086     VERTEX                         laird         
oracle          23974     VERTEX                         dickersw      
oracle          23976     VERTEX                         dickersw

I'm currently bouncing the server every week to clean out these dead processes. I don't want to treat my Oracle database like a NT box. Please help...

Thanks in Advance,
Satar

--
Oracle DBA/UNIX System Admin
"Opinions are the result of the voices in my head only,
and do not reflect my employer or Oracle Corporation."


Sent via Deja.com http://www.deja.com/
Before you buy.