cursor_sharing setting

From: Cee Pee <carlospena999_at_gmail.com>
Date: Fri, 7 Feb 2020 11:27:12 -0600
Message-ID: <CAPTPB13OyBg8MXdCi7cOzm-jrg=Q1aY0nj1=7XV=UV+QQfn=XQ_at_mail.gmail.com>

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?

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Feb 07 2020 - 18:27:12 CET

This message: [ Message body ]
Next message: Mladen Gogala: "Re: convert big endian to medium endian"
Previous message: ahmed.fikri_at_t-online.de: "AW: RE: convert big endian to medium endian"
Next in thread: Chris Taylor: "Re: cursor_sharing setting"
Reply: Chris Taylor: "Re: cursor_sharing setting"
Reply: l.flatz_at_bluewin.ch: "Re: cursor_sharing setting"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message