Catalog access taking 10 seconds or more -
04-03-2006
, 01:25 AM
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_DOUBL E',8,'LONG
RAW',2147483647,'LONG',2147483647,'CLOB',214748364 7,'NCLOB',2147483647,'BLOB',2147483647,'BFILE',214 7483647,'CHAR',char_length,'NCHAR',char_length,'VA RCHAR2',char_length,'NVARCHAR2',char_length,'NUMBE R',NVL(data_precision+2,40),data_length),... |