Hi,
I've a several 100 thousand line application. I did not introduce this issue,
but I need to fix it.
prepare_cached(SELECT foo FROM A where X = ?)
statement handle MyDBI::st=HASH(0xd630194) was still active at X.pm
I've tried turning on $dbh->(12, 'file.trace') and looking for all things
Hi all,
Just a note to all who might've sent me patches, emailed me (thanks!). I
was sick this week and also became emmersed in work on the federated
storage engine. I am in the process of putting together a 3.0008 release
of DBD::mysql that I intend to get released next week.
That's all!
K
Thanks for your direction, Ron.
-Original Message-
From: Reidy, Ron [mailto:[EMAIL PROTECTED]
Sent: Friday, September 22, 2006 1:05 PM
To: Kong, Alan; Alexander Foken
Cc: dbi-users@perl.org
Subject: RE: Does any one experiencing this problem?
This is not a DBI issue. In Oracle, orphane
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.
-
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 bro
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 i
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
behavi
See attached Oracle Troubleshooter Howto.
(List readers: Sorry, the list does not seem to accept HTML attachments)
Alexander
On 22.09.2006 16:55, Christophe ANTOINE wrote:
I see that you've added the path to your oracle home to your PATH
environment variable, but have you added ORACLE_HOME to
With dbi:Oracle or DBI:Oracle, it's the same problem.
Under Linux, the correct command is : DBI:Oracle.
Regards.
-Message d'origine-
De : John Scoles [mailto:[EMAIL PROTECTED]
Envoyé : vendredi 22 septembre 2006 17:02
À : Christophe ANTOINE; dbi-users@perl.org
Objet : Re: DBI->connect Or
it is dbi:Oracle:
not DBI:Oracle
it is case sensitive.
cheers
John Scoles
- Original Message -
From: "Christophe ANTOINE" <[EMAIL PROTECTED]>
To:
Sent: Friday, September 22, 2006 10:29 AM
Subject: DBI->connect Oracle on Windows, doesn't Work
Hello,
I have this script under, it d
>I see that you've added the path to your oracle home to your PATH
>environment variable, but have you added ORACLE_HOME to your
>environment?
Yes i have added the ORACLE_HOME on my environment where it define the
directory of my oracle client installation.
-Message d'origine-
De : Jef
I have this script under, it doesn't work.
I have installed the module DBD-Oracle on my Windows platform, I have a
Oracle client who's working in SQLplus mode.
I see that you've added the path to your oracle home to your PATH
environment variable, but have you added ORACLE_HOME to your
enviro
Hello,
I have this script under, it doesn't work.
I have installed the module DBD-Oracle on my Windows platform, I have a Oracle
client who's working in SQLplus mode.
Please help me, to configure my platform or my perl module to work with Oracle
with a Windows Platform.
# SC
13 matches
Mail list logo