From usidba@yahoo.com Tue, 03 Jul 2001 08:38:19 -0700 From: "Jerry C" Date: Tue, 03 Jul 2001 08:38:19 -0700 Subject: Re: CURSOR_SHARING = FORCE ques. Message-ID: MIME-Version: 1.0 Content-Type: text/plain Title: CURSOR_SHARING = FORCE ques. I've used it here quite a bit, w/ version 8.1.6. Most of the time it helps (expecially Broadvision apps, where I've seen SQL cache miss rates go from 50-70% to <10%). I've had one occasion where my miss rate actually went *up*. It's a dynamic parameter, so try it out - if you don't like what you see, change it back...     - Jerry
----- Original Message -----
From: Ivan_Rivera@doh.state.fl.us To: Multiple recipients of list ORACLE-L Sent: Monday, July 02, 2001 6:32 PM Subject: CURSOR_SHARING = FORCE ques. Gurus.... Well the boss is now getting on my back for me to upgrade my OCP to 8i.  I know, I know, I wasn't going to, please don't flame me, but work is insisting that I do.  So now I'm studying the upgrade book and it's sparked up a couple of questions regarding cursor_sharing = force. 1) I've heard a bunch of negative things (like bugs) regarding using this feature, was this just with 8.1.6 or is it still buggy? 2) Anyone out there using it?  Does it give that much better performance gains?  It seems to me like it's not worth implementing. 3)Can the guys playing with 9i out there verify if this is buggy in 9i? Thanks to all. Ivan Rivera