Re: 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
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">

• Original Message ----- <DIV style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: <A href="mailto:Ivan_Rivera_at_doh.state.fl.us" title=Ivan_Rivera_at_doh.state.fl.us>Ivan_Rivera_at_doh.state.fl.us To: <A href="mailto:ORACLE-L_at_fatcity.com" title=ORACLE-L_at_fatcity.com>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