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: OPTIMIZER_INDEX_COST_ADJ & OPTIMIZER_INDEX_CACHING

Re: OPTIMIZER_INDEX_COST_ADJ & OPTIMIZER_INDEX_CACHING

From: Micha³ Kuratczyk <kura_at_lj.pl>
Date: Fri, 09 Jun 2006 16:18:38 +0200
Message-ID: <e6bvts$sl0$1@abg.com.pl> 





nirav wrote:


> I have both of these parameters . set at their default values in my db.

> (100 & 0 respectively.) That however might not be the correct setting ,

> so could you please guide on how to decide the correct setting for

> these parameters for the database(version 9.2.0.6)?




Forget about these parameters and gather system statistics using
DBMS_STATS.GATHER_SYSTEM_STATS instead.


-- 
Michal Kuratczyk


Received on Fri Jun 09 2006 - 09:18:38 CDT












Original text of this message













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