UNIX child processes

From: <pminnis_at_sigeco.com>
Date: Tue, 01 Feb 2000 19:34:51 GMT
Message-ID: <877cgr$ugv$1@nnrp1.deja.com>

We are running Oracle Applications on a Digital UNIX platform -- but I have duplicated the effect with simple shell script with sqlplus as follows:

Shell script written to call sqlplus with PL/SQL block as in:

   when oserror exit failure rollback;
   when sqlerror exit failure rollback;    sqlplus user/pass <<EOF
   define

...

begin

...

end;
/

I find the unix pid that corresponds with the sqlplus and I find the shell script

I close my telnet session

Shell script process is gone. sqlplus pid continues running; it is definitely running -- I can watch the CPU% changing up and down.

This seems to be normal behavior on our system. Children continue to run without a parent.

So my question is, why doesn't the child process go away? Is there a way to subvert this behavior? Would I want to?

Oracle Applications DBA's:
This is occurring when we cancel a custom concurrent request. These programs are written as host shell scripts which run sqlplus, perhaps multiple times in the same shell script.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Feb 01 2000 - 13:34:51 CST