Re: Detecting whether the RBO or CBO is being used

From: Chris Leonard <chris_at_databaseguy.com>
Date: 17 Jun 2002 15:27:10 -0700
Message-ID: <b8cc3cda.0206171427.56230eb6@posting.google.com>

I assume you mean "choose" and not "rule" ... ??? Just a sanity check. Also, do you have the necessary statistics generated?

HTH,
Chris

---

Chris Leonard
MCSE, MCDBA, MCT, OCP, CIW
The Database Guy at PPI
http://www.propoint.com
Brainbench MVP for Oracle Admin
http://www.brainbench.com

alhepworth_at_hotmail.com (Alan) wrote in message news:<9920a15d.0206170208.4e0f8c07_at_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 - 17:27:10 CDT