Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: RE: Setting Cursor Sharing = Force in

RE: RE: Setting Cursor Sharing = Force in

From: <>
Date: Tue, 01 Oct 2002 09:09:45 -0800
Message-ID: <>

We are in and the bug 2225065 is not there.

>From: "Jesse, Rich" <>
>Date: Sat, 28 Sep 2002 08:27:34 -0500
>Subject: RE: Setting Cursor Sharing = Force in >


>We are currently using CS=F on and >we'll be patching to
>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 Quad/Tech International, Sussex, WI USA

> -----Original Message-----
> From: Nat []
> Sent: Friday, September 27, 2002 3:13 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Setting Cursor Sharing = Force in
> 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
Fax: 310.760.5914

Please see the official ORACLE-L FAQ:

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services
To REMOVE yourself from this mailing list, send an E-Mail message
to: (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).
Received on Tue Oct 01 2002 - 12:09:45 CDT

Original text of this message