Re: cursor_sharing - similar vs force

When one client moved from EXACT to FORCE, they had ORA-937 errors on queries 
that used to run fine.  The client was using 
Microsoft's OLEDB driver.  Oracle bug 1988231.  Ouch.  

Mary Elizabeth McNeely




________________________________
From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
To: adar666@xxxxxxxxxxxx
Cc: ORACLE-L <Oracle-L@xxxxxxxxxxxxx>
Sent: Thu, June 10, 2010 3:20:07 AM
Subject: Re: cursor_sharing - similar vs force


That certainly used to be true, but more and more vendors are providing 
somewhat functional methods of modifying either SQL directly or extending their 
application, for targetted intervention theres often a better method than a 
system wide hack. 
Niall Litchfield
On Jun 10, 2010 7:31 AM, "Yechiel Adar" <adar666@xxxxxxxxxxxx> wrote:
>
>
>>I think that your comment id right on the nail, for in house
>applications.
>>The problem is with bought packages where you can not make changes.
>>I this case cursor sharing makes sense.
>Adar Yechiel
>Rechovot, Israel
>>
>
>
>Kerry Osborne wrote:
>>
>> In general, though I think of cursor_sharing as a bandaid that should b...

Other related posts: