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