RE: Does any one experiencing this problem?

This is not a DBI issue. In Oracle, orphaned processes are harvested by
the SMON process. Your DBA should know this and be able to act
accordingly by setting SQL*Net parameters on the server and waking up
the SMON process to harvest the orphans.

--
Ron Reidy
Lead DBA
Array BioPharma, Inc.

-----Original Message-----
From: Kong, Alan [mailto:KongA@xxxxxxxxx]
Sent: Friday, September 22, 2006 10:09 AM
To: Alexander Foken
Cc: dbi-users@xxxxxxxx
Subject: 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/


This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is intended
to be for the use of the individual or entity named above. If you are not the
intended recipient, please be aware that any disclosure, copying, distribution
or use of the contents of this information is prohibited. Please notify the
sender of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

.

Relevant Pages

  • 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)
  • Re: float bug? perl 5.8, DBI and oracle 10.2.0
    ... If you want to store high precision numbers in oracle, you've got 38 decimal digits to play with, and with minimal coaxing perl will handle them as strings at the appropriate points so that the exact values go in and come out. ... I haven't done any numerical work in 10 years or so, but I seem to recall that one can reasonably expect 6 or so decimal significant digits from a 32 bit floating point number - I'll go out on a limb and hazard that one can expect 12 or so digits from a 64 bit floating point number - at any rate I'd be very surprised to get 18 significant digits. ...
    (perl.dbi.users)
  • RE: Memory fault(coredump) with two DBD type connections
    ... I get a core dump ... all the libraries are the same threaded model(single threaded perl uses ... I am running Perl 5.8.8 with DBD-Oracle 1.19 compiled against Oracle ... when I try to connect to the same Oracle database AND same DB2 database ...
    (perl.dbi.users)
  • Re: Is perl better? :(((
    ... >> Wasthe original PERL script hitting an Oracle database? ... >> Did you run an explain plan on your Oracle SQL? ... Java and perl on another. ...
    (comp.lang.java.databases)
  • Re: Is perl better? :(((
    ... >> Wasthe original PERL script hitting an Oracle database? ... >> Did you run an explain plan on your Oracle SQL? ... Java and perl on another. ...
    (comp.lang.java.programmer)