Re: PLEASE Help Me Kill Them (process not dying)

Satar
If you are really running 7.3.4.0.0, this base release has serious problems on User Process managment and cleanup. You have to apply latest patch 7.3.4.5.0 to get rid of them. There are nasty memory leak problems with this release as well.
Regards
Reza

Satar <satar_at_my-deja.com> wrote in message news:8jgfjd$vq7$1_at_nnrp1.deja.com...
> 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.
Received on Fri Jun 30 2000 - 00:00:00 CDT