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

Home -> Community -> Mailing Lists -> Oracle-L -> CBO parameters

CBO parameters

From: Kirsh, Gary <gary.kirsh_at_gs.com>
Date: Wed, 31 May 2000 12:26:02 -0400
Message-Id: <10514.107328@fatcity.com> 





Does anybody have any words of wisdom to share regarding tuning the CBO with
the init.ora parameters


OPTIMIZER_INDEX_COST_ADJ



OPTIMIZER_INDEX_CACHING



We're looking to come up with some good values to use for these across all
our instances.  I know that our mileage will vary, but has anybody seen any
benefit by changing these from their default values?



TIA,



Gary



Gary Kirsh


Next Extent, Inc
Received on Wed May 31 2000 - 11:26:02 CDT












Original text of this message













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