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 -> rbo to cbo

rbo to cbo

From: Oradba Linux <techiey2k3_at_comcast.net>
Date: Sat, 8 Jan 2005 16:09:26 -0500
Message-ID: <BsWdndhwILZ91n3cRVn-tg@comcast.com> 





what parameters to pay attention to other than the following moving from RBO
to CBO?


It is an OLTP instance.


optimizer_mode
optimizer_features_enable
optimizer_index_caching
optimizer_index_cost_adj
optimizer_dynamic_sampling
optimizer_max_permutations





What about these two parameters?


hash_area_size


hash_join_enabled



Thanks
Received on Sat Jan 08 2005 - 15:09:26 CST












Original text of this message













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