Re: Stored Outline

You might be hitting bug 6455659.

In my case, dba_outlines was showing the outline as USED but it was not taking effect.

Rakesh

On Wed, Jul 22, 2009 at 5:13 PM, Stalin<stalinsk_at_gmail.com> wrote:
> All,
>
> 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"
>
> Thanks,
> Stalin
>
> Platform: 10gR2 (10.2.0.4), Sol10.
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l