Oracle-L: Re: cursor_sharing in 8.1.7.4

From: raju pa <raju_pa_24_at_yahoo.com>
Date: Tue, 19 Aug 2003 11:49:24 -0800
Message-ID: <F001.005CB92C.20030819114924@fatcity.com>

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

Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: raju pa
  INET: raju_pa_24_at_yahoo.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 - 14:49:24 CDT

Re: cursor_sharing in 8.1.7.4 - good or bad