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 >> >> >> > >
