RE: Does any one experiencing this problem?

Alexander,

This is the problem for me because I am using PERL as CGI for web
applications where the script is querying the data from Oracle database.
And if the process is taking too long to return the data to user
browser, sometimes, the user will then close the browser or click "STOP"
in the browser. In that case, the Oracle process will be staying there
forever. This led to the problem of Oracle backup process which is
waiting for all processes to complete. Therefore, we need to do a clean
up on those orphan processes periodically. But because of all Oracle
child processes initiated by PERL are with parent id of 1, the clean up
process doesn't know which one is supposed to removed.

Thanks in advance.
Alan



-----Original Message-----
From: Alexander Foken [mailto:alexander@xxxxxxxx]
Sent: Friday, September 22, 2006 11:49 AM
To: Kong, Alan
Cc: dbi-users@xxxxxxxx
Subject: Re: Does any one experiencing this problem?

Why is that a problem for you?

If you are running some kind of Unix, process 1 is init ("the parent of
all processes"), new processes with a parent id of 1 are simply new,
independant process groups, that do not get killed when the process
group with your perl script is killed. (I think this is an isolated
transaction-handling process forked by the oracle client library.) man
2 setsid

If you are running Windows, ID 1 is NOT special.

Alexander

On 22.09.2006 17:27, Kong, Alan wrote:
Hi all,

My system is running an Oracle10G server with PERL DBI, whenever I run

the perl scripts with DBD connect, there will be an Oracle sub-process

with parent ID of 1. Normally, the sub-process should have a parent
ID = pid of the perl script. Running any other scripts with SQL*PLUS
is behaving normal though.

Does anyone have experience the same problem before?

Thanks,
Alan




--
Alexander Foken
mailto:alexander@xxxxxxxx http://www.foken.de/alexander/

.

Relevant Pages

  • Re: Apache, Oracle, Perl DBI Problems
    ... I believe at the start of every perl cgi script interfacing ... 'perl dbi oracle'. ...
    (perl.dbi.users)
  • Re: install_driver(Oracle) failed: wrong ELF class: DynaLoader.pm
    ... I'm not the Oracle expert - treat what I say with a pinch of salt. ... So, if your Perl script sets LD_LIBRARY_PATH, ... Try modifying your cron job so that it runs a shell script which sets at ...
    (perl.dbi.users)
  • RE: DBI blues
    ... I am trying to install DBI to run a DBtest Script that was written ... I am not very familiar with Perl. ... or Oracle database. ...
    (perl.dbi.users)
  • RE: DBI blues
    ... Here is the error I got, the version, and the script I am trying to ... I am not very familiar with Perl. ... and by the looks of the script, you will later need the oracle and mysql dbds ... # database created by netMS. ...
    (perl.dbi.users)
  • Re: ANNOUNCE: DBD:Oracle 1.18
    ... Well a warning in one compiler is better than and error in an other so I ... This might be a problem more with the older oracle OCI in your client. ... perl -Mblib t/26exe_array.t ...
    (perl.dbi.users)