RE: cursor_sharing in 8.1.7.4 - good or bad

As a counterpoint, we've been using cursor_sharing=force in 8.1.7.4 on Linux for quite some time now and with great success. I'd say it's worth a try. The only problem I've seen with cursor_sharing=force is an incompatibility with certain processes in sqlloader, but nothing we can't work around.  

Cursor_sharing in 8.1.7.2 was a complete disaster on Linux, but they seem to have gotten it working well in 8.1.7.4.  

--Walt Weaver

   Bozeman, Montana  

-----Original Message-----
Sent: Tuesday, August 19, 2003 1:49 PM
To: Multiple recipients of list ORACLE-L  

Hi,
  No. I recommend that you do not change cursor_sharing if you are doing it just to get rid of 4031. There could be serious problems. ora-600 etc. Maybe Oracle has fixed everything in latest 817 but I suggest not to take that chance.
  For 4031 you can do the following : pin pl/sql sql preferably at startup, use bind variables and periodically check for sql not using bind variables. Goodluck.

"Fedock, John (KAM.RHQ)" <John.Fedock_at_us.kline.com> wrote:          

        Does anyone have any experience using cursor_sharing in 8.1.7.4? I feel I need to use it due to literal SQL statements being used. We have had misc 4031 errors off and on and I feel this is my last hope. I have a very busy OPFS server (HP-UX).          

        I did try using cursor_sharing in 8.1.7.2, and I remember incorrect sorting and other unexpected results happening.          

        Thanks for any input.                    

        John                    

	John Fedock 
	"K" Line America, Inc. 
	www.kline.com <http://www.kline.com/>   
	* john.fedock_at_us.kline.com 
	 
	 

Do you Yahoo!?
SBC Yahoo! DSL
<http://pa.yahoo.com/*http:/rd.yahoo.com/evt=1207/*http:/promo.yahoo.com /sbc/> - Now only $29.95 per month!

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Weaver, Walt
  INET: wweaver_at_rightnow.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).