Re: Stored Outline
Date: Wed, 22 Jul 2009 21:56:44 -0700
You might be hitting bug 6455659.
In my case, dba_outlines was showing the outline as USED but it was not taking effect.
On Wed, Jul 22, 2009 at 5:13 PM, Stalin<stalinsk_at_gmail.com> wrote:
> We recently had a performance issue on a SQL for which we had stored
> outlined defined for it. Wondering if oracle an skip stored outline by
> any means.
> We created outline using create_outline(hash_value, child_number) from
> the child cursor in shared pool which had the good plan. And enabled
> outline at system level and also to kept persistent across DB restart
> via DB startup trigger.
> The SQL in question is using bind variables though. Something along
> the lines of "Select * from tablename where col1 = :1 and col2 = :2
> and col3 = :3"
> Platform: 10gR2 (10.2.0.4), Sol10.