Re: Stored Outline
- From: Rakesh Tikku <rakesh.tikku@xxxxxxxxx>
- To: stalinsk@xxxxxxxxx
- Date: Wed, 22 Jul 2009 21:56:44 -0700
Stalin,
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@xxxxxxxxx> 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.
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
