Catalog access taking 10 seconds or more

From: J Huntley Palmer <jh_at_dontspam.spam>
Date: Mon, 03 Apr 2006 01:25:36 -0400
Message-ID: <1231cei2lrovna7@news.supernews.com>

I am getting this request from an oracle ODBC driver attached to some PC based development tools. MS Access is one of them. Regardless, when there is catalog information needed this statement gets called and takes 10 seconds to resolve on a database that otherwise is quick and efficient for regular user data selects and updates.

I am using Release 10.2.0.1.0 on Solaris9 SPARC.

Any ODBC configs to make?

SELECT /*+ RULE */ '',owner,table_name,column_name,0,data_type, data_precision, decode(data_type,
'DATE',16,'FLOAT',8,'BINARY_FLOAT',4,'BINARY_DOUBLE',8,'LONG RAW',2147483647,'LONG',2147483647,'CLOB',2147483647,'NCLOB',2147483647,'BLOB',2147483647,'BFILE',2147483647,'CHAR',char_length,'NCHAR',char_length,'VARCHAR2',char_length,'NVARCHAR2',char_length,'NUMBER',NVL(data_precision+2,40),data_length),... Received on Mon Apr 03 2006 - 00:25:36 CDT