Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: cursor_sharing in 8.1.7.4 - good or bad
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
-- 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
![]() |
![]() |