Re: Getting costs for hypothetical query plans

From: William Robertson <williamr2019_at_gmail.com>
Date: Sat, 26 Feb 2011 01:03:22 -0800 (PST)
Message-ID: <91bd0a04-88aa-40e3-8bf9-7c8fd3bc0f8c_at_t8g2000vbd.googlegroups.com>

On Feb 25, 4:58 pm, Tom Anderson <t..._at_urchin.earth.li> wrote:
> Hi,
>
> We have a query which has a surprising plan. I assume Oracle considered
> the right plan, but rejected it. Is there any way to tell it that plan,
> and have it tell me the cost breakdown of it? That would really help me
> figure out what's going wrong.

Sounds like you want a 10053 CBO trace.
http://asktom.oracle.com/pls/apex/f?p=100:11:0::NO::P11_QUESTION_ID:63445044804318 http://tonguc.wordpress.com/2007/01/20/optimizer-debug-trace-event-10053-trace-file Received on Sat Feb 26 2011 - 03:03:22 CST