RE: cursor_sharing in 8.1.7.4 - good or bad

From: Gudmundur Bjarni Josepsson <gbj_at_index.is>
Date: Wed, 20 Aug 2003 07:21:00 -0800
Message-ID: <F001.005CBC20.20030820072100@fatcity.com>

I know of a site that has been using cursor_sharing=force on 8.1.7 for over two years now with no noticeable side-effects (except that many of the programmers still think it's okay to use literals).  

Gudmundur    

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
* john.fedock_at_us.kline.com  

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Gudmundur Bjarni Josepsson
  INET: gbj_at_index.is

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). Received on Wed Aug 20 2003 - 10:21:00 CDT