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.