cursor_sharing in 8.1.7.4 - good or bad

From: Fedock, John (KAM.RHQ) <John.Fedock_at_us.kline.com>
Date: Tue, 19 Aug 2003 10:49:26 -0800
Message-ID: <F001.005CB8FD.20030819104926@fatcity.com>

 

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: Fedock, John (KAM.RHQ)
  INET: John.Fedock_at_us.kline.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). Received on Tue Aug 19 2003 - 13:49:26 CDT