Re: Thank you Oracle Support - cursor_sharing = similiar is deprecated!
- From: kyle Hailey <kylelf@xxxxxxxxx>
- To: andrew.kerber@xxxxxxxxx
- Date: Tue, 23 Nov 2010 21:27:58 -0800
sounds like it's about time
http://db-optimizer.blogspot.com/2010/06/cursorsharing-picture-is-worth-1000.html
<http://db-optimizer.blogspot.com/2010/06/cursorsharing-picture-is-worth-1000.html>tried
on 11g last week and the results for similar were even worse :)
Best
Kyle
On Tue, Nov 23, 2010 at 9:10 AM, Andrew Kerber <andrew.kerber@xxxxxxxxx>wrote:
> Nope, you are not the last. This is news to me, though I always
> recommended using either exact or force, depending on the circumstance.
> Similar always seemed like the worst of both worlds to me.
>
>
> On Tue, Nov 23, 2010 at 10:48 AM, Carol Dacko <dackoc@xxxxxxxxx> wrote:
>
>> Maybe I am the last person to the know but Doc ID: 1169017.1 is the
>> announcement that cursor_sharing = similar is now deprecated in 11g! And
>> the write up is very good. And it is great that they also included in the
>> references the Optimizer Team's blog about it too.
>>
>> So yes, thank you Oracle Support! I really do appreciate this! This will
>> now be one more battle I don't need to fight!
>>
>> Warm regards,
>> Carol Dacko
>> University of Michigan
>>
>>
>>
>
>
>
> --
> Andrew W. Kerber
>
> 'If at first you dont succeed, dont take up skydiving.'
>
Other related posts:
