Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Catalog access taking 10 seconds or more

Re: Catalog access taking 10 seconds or more

From: J Huntley Palmer <jh_at_dontspam.spam>
Date: Mon, 03 Apr 2006 15:07:35 -0400
Message-ID: <1232sjo95618a04@news.supernews.com> 





Frank van Bortel wrote:


> J Huntley Palmer wrote:

> 


>> SELECT /*+ RULE */ '',owner,table_name,column_name,0,data_type,
>> data_precision, decode(data_type,




> 

> The Rule based optimizer died in 10G. Try without, with system

> statistics, with catalog statistics.

> 




Any directions would be greatly appreciated. Also this is being 
generated by some development application or the ODBC driver it uses.



Thanks
Received on Mon Apr 03 2006 - 14:07:35 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US