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
