RE: cursor_sharing in 8.1.7.4 - good or bad

[Weaver, Walt]

As a counterpoint, we’ve been using cursor_sharing=force in 8.1.7.4 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 8.1.7.2 was a complete disaster on Linux, but they seem to have gotten it working well in 8.1.7.4.   --Walt Weaver    Bozeman, Montana   -----Original Message----- From: raju pa [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 19, 2003 1:49 PM To: Multiple recipients of list ORACLE-L Subject: 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)" <[EMAIL PROTECTED]> 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  * [EMAIL PROTECTED]     Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month!