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 -> Detecting whether the RBO or CBO is being used

Detecting whether the RBO or CBO is being used

From: Alan <alhepworth_at_hotmail.com>
Date: 17 Jun 2002 03:08:52 -0700
Message-ID: <9920a15d.0206170208.4e0f8c07@posting.google.com> 





Hi


I'm investigating some performance problems within our system and am
looking at the explain plans for some sql. On one box (v8.1.7) when I
run the following:



alter session set optimizer_mode = rule   
select blah from blah where blah



I can see that plan and no costs are present.



When I run it on our v8.0.5 box, I can see costs in the plan. Does
this mean that the optimizer_mode is not set to rule for some reason?



Thanks in advance


Alan
Received on Mon Jun 17 2002 - 05:08:52 CDT












Original text of this message













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