I recently used it on 8.1.7.4 and 9i. I gained 33% performance gain. It would be different depending on how much literal SQL is used in your code.
My process ran fine, and I was able to load the data. However, I have not fully checked the data yet. Shakir --- "Johnson, Michael " <[EMAIL PROTECTED]> wrote: > I went thru this recently ... > > The best thing to do is to FORCE the developers to use > bind variables and then this is no longer an issue. > > If you do set it to FORCE , I believe there is a problem > with it in versions 8.1.6 and before and it should not be > used. Double Check with Metalink on this. > > FWIW ... Mike > > -----Original Message----- > Sent: Friday, September 27, 2002 1:13 PM > To: Multiple recipients of list ORACLE-L > > > 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, > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Nat > 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). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Johnson, Michael > 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). ===== Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __________________________________________________ Do you Yahoo!? New DSL Internet Access from SBC & Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammed Shakir 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).