Re: Getting costs for hypothetical query plans

From: William Robertson <>
Date: Sat, 26 Feb 2011 01:03:22 -0800 (PST)
Message-ID: <>

On Feb 25, 4:58 pm, Tom Anderson <> 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. Received on Sat Feb 26 2011 - 03:03:22 CST

Original text of this message