I was using DBD::Oracle 1.20 in development, and DBD::Oracle 1.21 in integration, test and production. So far we have only deployed DBD::Oracle to development. Would you recommend to install something else for integration, test and production?
We had DBI 1.602 in development, and we were having trouble installing DBD::Oracle 1.23, so we upgraded to DBI 1.609 and that seemed to fix the problem. What DBI and DBD::Oracle do you recommend for production use? John -----Original Message----- From: John Scoles [mailto:sco...@pythian.com] Sent: Friday, February 05, 2010 9:52 AM To: Carlson, John W. Cc: Matthew Maglinte; dbi-users@perl.org; tim.bu...@pobox.com Subject: Re: dbd::oracle behavior 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:sco...@pythian.com] > Sent: Friday, February 05, 2010 9:31 AM > To: Carlson, John W. > Cc: Matthew Maglinte; dbi-users@perl.org; tim.bu...@pobox.com > 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:sco...@pythian.com] >> Sent: Friday, February 05, 2010 5:07 AM >> To: Matthew Maglinte >> Cc: dbi-users@perl.org; tim.bu...@pobox.com >> 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 >>> matthew_magli...@dot.ca.gov >>> >>> >>> >>> >> >> > >
