Re: Getting costs for hypothetical query plans
Date: Sat, 26 Feb 2011 01:03:22 -0800 (PST)
On Feb 25, 4:58 pm, Tom Anderson <t..._at_urchin.earth.li> wrote:
> 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