We are in 8.1.7.0 and the bug 2225065 is not there.
>From: "Jesse, Rich" <[EMAIL PROTECTED]> >Date: Sat, 28 Sep 2002 08:27:34 -0500 >Subject: RE: Setting Cursor Sharing = Force in >8.1.7.3 >Nat, >We are currently using CS=F on 8.1.7.2 and >we'll be patching to 8.1.7.4 >soon. You need to be made aware of some severe >problems with this in 8i. >We've run across BUG 2225065 listed on >MetaLink. It says that you can >actually get incorrect results in certain >queries when using CS=F. Luckily >one of our developers noticed the very subtle >problem and we were able to >use ALTER SESSION SET CURSOR_SHARING=EXACT for >his particular program. The >catch is finding all the affected queries! >Also, we get sporadic ORA-600s that can be >attributed to CS=F, but it hasn't >been a showstopper yet. For more CS=F issues, >you will want to check >Metalink doc 120607.1. It has pointers to the >docs that have all the fixes >for all the 8.1.7.x releases. There are a few >important fixes in .3 and .4. >Offhand, I don't remember if the BUG I >mentioned is fixed in either release. ..... HTH! GL! :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -----Original Message----- > From: Nat [mailto:[EMAIL PROTECTED]] > Sent: Friday, September 27, 2002 3:13 PM > To: Multiple recipients of list ORACLE-L > Subject: Setting Cursor Sharing = Force in 8.1.7.3 > > > We are looking into setting up cursor_sharing parameter to FORCE. Has > anyone seen any bad effects of setting Cursor_sharing=FORCE. > Are there any > real bad effects of setting it..? > > I was thinking of going back to my developers and make them use bind > variables in their code. > If I set the above parameter, they may continue to develop > their code the > way it is now. > > Let me know what you all think about it.. > > Thanks in advance, Ricardo Maurino Oracle Dba. Tornado Development, Inc. Phone: 310.760.9239 Email: [EMAIL PROTECTED] Fax: 310.760.5914 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).