RE: RE: Setting Cursor Sharing = Force in 8.1.7.3

We are in 8.1.7.0 and the bug 2225065 is not there.

>From: "Jesse, Rich" <Rich.Jesse_at_qtiworld.com>
>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 Rich.Jesse_at_qtiworld.com Quad/Tech International, Sussex, WI USA

> -----Original Message-----
> From: Nat [mailto:nat2710_at_hotmail.com]
> 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: rmaurino_at_tornadodev.com
Fax: 310.760.5914

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: rmaurino_at_tornadodev.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).