RE: Setting Cursor Sharing = Force in 8.1.7.3

From: Johnson, Michael <Michael.Johnson_at_oln-afmc.af.mil>
Date: Fri, 27 Sep 2002 13:08:34 -0800
Message-ID: <F001.004DBAE5.20020927130834@fatcity.com>

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: nat2710_at_hotmail.com

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: ListGuru_at_fatcity.com (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: Michael.Johnson_at_oln-afmc.af.mil

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------