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: RBO to CBO

Re: RBO to CBO

From: Buck Turgidson <jc_va_at_hotmail.com>
Date: Fri, 6 Aug 2004 08:28:18 -0400
Message-ID: <f4acu1-3qo.ln1@hp.coleman.com> 





>

> > Be sure to work through various permutations of the

> > optimizer_index_caching and optimizer_index_cost_adj

> > parameters.

>

> For an OLTP system I'll set OPTIMIZER_MODE to FIRST_ROWS_n (choose n

> according to your application, usually 10 or 100 is good).




There are also scripts around that will analyze your DB to see if histograms
are indicated.
Received on Fri Aug 06 2004 - 07:28:18 CDT












Original text of this message













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