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.JohnJohn Fedock
"K" Line America, Inc.
www.kline.com
* [EMAIL PROTECTED]
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
