Re: dbd::oracle behavior

Fri, 05 Feb 2010 09:48:53 -0800

should be no problem then what was the original version of DBD:Oracle and DBI where you using?? 
So far, I am read only!

Thanks,

John

-----Original Message-----
From: John Scoles [mailto:[email protected]] Sent: Friday, February 05, 2010 9:31 AM 
To: Carlson, John W.
Cc: Matthew Maglinte; [email protected]; [email protected]
Subject: Re: dbd::oracle behavior
The bug in 1.23 will hit you if you try to an insert more than one CLOB at a time. 
If you are not inserting CLOBs then do not worry about it.

Cheers
John Scoles


Carlson, John W. wrote:

Uh.  I just installed DBD::Oracle 1.23 with a patch.  Should I install 
DBD::Oracle 1.22 instead?  What I the nature of the bug?
I am fairly new to the dbi-users group, and I haven't been watching the emails.

John

-----Original Message-----
From: John Scoles [mailto:[email protected]] Sent: Friday, February 05, 2010 5:07 AM 
To: Matthew Maglinte
Cc: [email protected]; [email protected]
Subject: Re: dbd::oracle behavior
Hard to say what is going on here but me things you are running into the 'ping' problem 

Are you using Apache::DBI??
Many of these warehouse applictions reuse the same connection handel and to keep them alive they use $dbh->ping which runs a query to maintain the connection. 

What version of DBD::Oracle are you using?
If you can upgrade to DBD::Oracle 1.22 (do not use 1.23 there is a bug in there that might be worse) or get the latest 1.24 version 

that might solve your problem

cheers
John Scoles






Matthew Maglinte wrote:
I'm a dba supporting a warehouse database (production environment) accessed via a custom application built on open source components, one of which is dbd::oracle.
Performance monitoring shows two queries continually consuming considerable resources (cpu waits) - the query text resembling for the most part 'column_info' and 'table_info'. Over any given day, the column_info select is executed +260 times an hour, 'table_info' executed +360 times an hour.
Is this level of frequency intended? And are these calls appropriate (expected) for a static data dictionary environment?
Any response that would help my understanding would be appreciated. Thanks. 

Matt Maglinte
DBA - PeMS/LCS
Department of Transportation
W:(916)445-0090
[email protected]

Reply via email to