dbTalk Databases Forums  

Catalog access taking 10 seconds or more

comp.databases.oracle.server comp.databases.oracle.server


Discuss Catalog access taking 10 seconds or more in the comp.databases.oracle.server forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
J Huntley Palmer
 
Posts: n/a

Default 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),...

Reply With Quote
  #2  
Old   
janu
 
Posts: n/a

Default Re: Catalog access taking 10 seconds or more - 04-03-2006 , 01:47 AM






hi
huntely

even iam getting the ssame requst from an oracle odbc

my name is
nalinie.
J Huntley Palmer wrote:
Quote:
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),...


Reply With Quote
  #3  
Old   
sooz
 
Posts: n/a

Default Re: Catalog access taking 10 seconds or more - 04-03-2006 , 01:51 AM



hai babes
? r u
i am 5ne.
hope u r g8.
r u not feeling board.


Reply With Quote
  #4  
Old   
janu
 
Posts: n/a

Default Re: Catalog access taking 10 seconds or more - 04-03-2006 , 01:53 AM



yes iam felling board.

sooz

the hole floor is verry board.


Reply With Quote
  #5  
Old   
janu
 
Posts: n/a

Default Re: Catalog access taking 10 seconds or more - 04-03-2006 , 02:01 AM



r u there u soo

what u r doing


& what happened to pooti

i think bird fluu.

right
soo


Reply With Quote
  #6  
Old   
sooz
 
Posts: n/a

Default Re: Catalog access taking 10 seconds or more - 04-03-2006 , 02:02 AM



let us go to a movie today


Reply With Quote
  #7  
Old   
janu
 
Posts: n/a

Default Re: Catalog access taking 10 seconds or more - 04-03-2006 , 02:03 AM



r u there u soo

what u r doing


& what happened to pooti

i think bird fluu.

right
soo


Reply With Quote
  #8  
Old   
sooz
 
Posts: n/a

Default Re: Catalog access taking 10 seconds or more - 04-03-2006 , 02:04 AM



ok will u come to movie babe's


Reply With Quote
  #9  
Old   
janu
 
Posts: n/a

Default Re: Catalog access taking 10 seconds or more - 04-03-2006 , 02:07 AM



at what time .
if evening means no .


Reply With Quote
  #10  
Old   
sooz
 
Posts: n/a

Default Re: Catalog access taking 10 seconds or more - 04-03-2006 , 02:09 AM



common my Princess u tell the time.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.