cursor_sharing setting

  • From: Cee Pee <carlospena999@xxxxxxxxx>
  • To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 7 Feb 2020 11:27:12 -0600

All,

I logged into a reasonably sized data warehouse system which I just
inherited. Apart from several surprises, I also see cursor sharing set to
Force. To me it looks very counter intuitive to set CS to force in a DW.  I
would think you would want the cursors to be parsed for almost all the
executions.  ver12 and uses star schema.  Thoughts?

CP.

Other related posts: