Re: Stored Outline
- From: Stalin <stalinsk@xxxxxxxxx>
- To: Rakesh Tikku <rakesh.tikku@xxxxxxxxx>
- Date: Thu, 23 Jul 2009 09:57:06 -0700
Thanks Rakesh.
I see that bug being reported in 11.1.0.6. But we are running
10.2.0.4. I better check with oracle on this.
Yes outlines was showing USED as well in our case but still choose the bad plan.
Stalin
On Wed, Jul 22, 2009 at 9:56 PM, Rakesh Tikku<rakesh.tikku@xxxxxxxxx> wrote:
> 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:
