Re: Catalog access taking 10 seconds or more

From: janu <mrinal.palle_at_gmail.com>
Date: 2 Apr 2006 22:47:21 -0700
Message-ID: <1144043241.423582.236950@z34g2000cwc.googlegroups.com>

hi
huntely

even iam getting the ssame requst from an oracle odbc

my name is
nalinie.
J Huntley Palmer wrote:
> 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:47:21 CDT