Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: cursor_sharing in - good or bad

RE: cursor_sharing in - good or bad

From: Weaver, Walt <>
Date: Tue, 19 Aug 2003 12:24:32 -0800
Message-ID: <>

As a counterpoint, we've been using cursor_sharing=force in 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 was a complete disaster on Linux, but they seem to have gotten it working well in  

--Walt Weaver

   Bozeman, Montana  

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

  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)" <> wrote:          

        Does anyone have any experience using cursor_sharing in 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, and I remember incorrect sorting and other unexpected results happening.          

        Thanks for any input.                    


	John Fedock 
	"K" Line America, Inc. <>   

Do you Yahoo!?
SBC Yahoo! DSL
<*http:/*http:/ /sbc/> - Now only $29.95 per month!

Please see the official ORACLE-L FAQ:
Author: Weaver, Walt

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 Aug 19 2003 - 15:24:32 CDT

Original text of this message