Re: defunct procs from Oracle 7.3

On Thu, 14 May 1998 06:58:36 GMT,
gcebac_at_my-dejanews.com <gcebac_at_my-dejanews.com> wrote:
>I am in the process of implementing an MRP solution, running on top of Oracle
>7.3 on AIX 4.21.
>
>The application is up and running, however, when I give a ps -aef command, I
>see many <defunct> processes, owned by init. The number of these processes
>seems to constantly grow.
>
>I have analysed these processes, and have found that prior to becoming
>defunct, they are the Child Process of an Oracle Process.
>
>The parent process information is :-
>
>oracle7 611566 611052 6 10:01:17 - 0:02 oracleWG73 (DESCRIPTI
>ON=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
>
>Being that I have next to no Oracle experience, I have no idea what this
>means. WG73 is the name of the Oracle instance.

It means Oracle or someone did some sloppy coding. The parent process that created the children is no longer around to acknowledge the children as they try to say they are finished. So they hang around defunct.

You might try using TCP instead of beq and see if that doesn't clean up after itself better.

It's also possible that the MRP software is calling Oracle, and should have a process started with a NOHUP, so it can wait for the child.

>
>Any help / ideas would be much appreciated.
>
>Thanks in Advance
>
>Graham Currie
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading

--
These opinions are my own and not necessarily those of Information Quest

or Pebble In The Sky                     http://www.informationquest.com

http://ourworld.compuserve.com/homepages/joel_garry jgarry@nospameiq.com
"See your DBA?"  I AM the @#%*& DBA!     Remove nospam to reply.  Sorry.