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: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Mon, 03 Apr 2006 20:19:03 +0200
Message-ID: <e0rotj$sa4$1@news5.zwoll1.ov.home.nl> 





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.


-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...


Received on Mon Apr 03 2006 - 13:19:03 CDT












Original text of this message













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