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: Query occasionally returning empty results in 8i

Re: Query occasionally returning empty results in 8i

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 09 Jun 2006 12:10:34 +0200
Message-ID: <n7ii82hpf1ljd0ligkarb1od8qtd689u44@4ax.com> 





On 9 Jun 2006 01:00:01 -0700, "BoukeB" <bbruinsma_at_ortec.nl> wrote:



>> If any table has statistics, the CBO will be used.  Otherwise, RBO will

>> be used.  Have you checked the statistics?

>I thougth this optimizer mode was the default. So omitting it should

>not induce different behaviour.





Your optimizer_goal parameter is on CHOOSE. This means you will only
use CBO when you have statistics.


--
Sybrand Bakker, Senior Oracle DBA


Received on Fri Jun 09 2006 - 05:10:34 CDT












Original text of this message













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