This sounds terribly familiar!
Check out comments in my Sys::SigAction module. Referred to in DBD::Oracle
docs I think. You may find something useful in there too. There is an
oracle specific POD and test script. I strongly suspect that Oracle OCI
libraries might be didling with signal() or
use warnings;
use strict;
$serial = 0800690COA; #is being converted to an octal number by perl
$serial = abc; # will give you an error with the above pragmas set.
Lincoln
-Original Message-
From: Jim Lynch [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 25, 2005 2:27 PM
To:
-Original Message-
From: Paul Appleby [mailto:[EMAIL PROTECTED]
Sent: Monday, October 18, 2004 4:54 PM
To: BAXTER, LINCOLN A
Cc: [EMAIL PROTECTED]
Subject: RE: Slow connection to Oracle 9i
No. Each user will be using the same application that logs in to the
same schema. But the users are all
]
Sent: Monday, October 18, 2004 4:39 PM
To: BAXTER, LINCOLN A
Cc: [EMAIL PROTECTED]
Subject: RE: Slow connection to Oracle 9i
My CGI application will be called by different users at different
times. Are you saying the first user's connection can be left open
for all the other users? How?
Paul
:[EMAIL PROTECTED]
Sent: Monday, October 18, 2004 3:51 PM
To: Paul Appleby; BAXTER, LINCOLN A
Cc: [EMAIL PROTECTED]
Subject: RE: Slow connection to Oracle 9i
Perhaps this'll help:
http://perl.apache.org/docs/1.0/guide/
performance.html#Persistent_DB_Connections
There's a link
To: Paul Appleby; BAXTER, LINCOLN A
Cc: [EMAIL PROTECTED]
Subject: RE: Slow connection to Oracle 9i
H...one thing I thought of is to check the validity of the handle, in
case the Oracle instance bounces (i.e. The Oracle instance is available,
but the persistent connection no longer exists). Does
-Original Message-
From: BAXTER, LINCOLN A
Sent: Tuesday, October 19, 2004 10:27 AM
To: 'Reidy, Ron'
Subject: RE: Slow connection to Oracle 9i
Actually it is CHEAP compared to a rollback, you have to reset your
transaction state.
Commit is the cheapest thing you can do in Oracle
]
Sent: Tuesday, October 19, 2004 10:39 AM
To: BAXTER, LINCOLN A
Cc: [EMAIL PROTECTED]
Subject: RE: Slow connection to Oracle 9i
Hmm...
I strongly disagree. To quote from Steve Adam's website
(http://www.ixora.com.au/newsletter/2001_09.htm)...
Over committed
Many applications commit more
Most people with experience with Oracle know that opening oracle connections
is SLOW!
Oracle does not appear to consider that a problem, just like they do not
consider slow performance for doing DDL a problem
Applications that require near real time (OLTP) response times open
connections once,
If you are running on a Unix like OS, see Sys::SigAction.
http://search.cpan.org/~lbaxter/Sys-SigAction/
There is a script/paper that demos how to use it with DBD::Oracle.
I suspect the same techniques can be used for MySQL.
Lincoln
-Original Message-
From: Steffen Breitbach
script.
Best,
Lincoln
-Original Message-
From: Henri Asseily [mailto:[EMAIL PROTECTED]
Sent: Friday, September 10, 2004 1:23 PM
To: BAXTER, LINCOLN A
Cc: 'Steffen Breitbach'; [EMAIL PROTECTED]
Subject: Re: Hangs while $st_query-execute();
Here's an example with Sys::SigAction
I sent him the README.hpux
-Original Message-
From: Wesley STROOP [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 08, 2001 10:32 AM
To: [EMAIL PROTECTED]
Subject: DBD-Oracle-1.06 installation problems on a HP-unix server
Hi all,
I installed the DBI modules(DBI-1.16) without problems on
I have not had a chance to try 1.15... it had some known other
problems and Tim will be releasing a new version soon.
Could you try to figure what the compile error is and then send that to the
list... (and to tim).
Once you have done that, I suggest you back down to perl 5.6.0
and DBI 1.14.
It looks like it cann't find the path to $ORACLE_HOME/lib libraries.
Try setting LD_LIBRARY_PATH... and make sure you have $ORACLE_HOME and
its family of EVs set.
Lincoln
-Original Message-
From: Peterson, Ted [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 23, 2001 3:25 PM
To: '[EMAIL
What are you selecting from? I do not think your select is valid SQL.
-Original Message-
From: Mark Stosberg [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 11, 2001 5:38 PM
To: [EMAIL PROTECTED]
Subject: can't find selectrow_hashref
Hello,
I'm now using and enjoying the new
Hi,
I have a daemon (using Net::Daemon) that uses DBI/DBD-Oracle in forked
children of the daemon.
When a client connects the daemon forks a child that then connects to the
database via DBD-Oracle.
Recently I decided to check all the database connections in the parent
during startup, and this
Thanks for the feedback...
Its going to be another week or so before I can get back to producing
any version of the instructions I will be certain to include
the g in the sed command in the next version. I believe it is already
in the patch.
-Original Message-
From: Steven Baldwin
17 matches
Mail list logo