Re: cursor_sharing setting

From: Chris Taylor <christopherdtaylor1994_at_gmail.com>
Date: Fri, 7 Feb 2020 13:08:11 -0500
Message-ID: <CAP79kiR2U94VpMhthJ0uTyLHK1RvV-HTepgNMyQgDQkK8t0jTQ_at_mail.gmail.com>



Kind of depends on if they're using a lot of dynamic SQL or an application that passes literals in all the time for repetitive queries (which should probably use a logon trigger instead of system-wide setting).

Just my $0.02
Chris

On Fri, Feb 7, 2020 at 12:28 PM Cee Pee <carlospena999_at_gmail.com> wrote:

> 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.
>

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Feb 07 2020 - 19:08:11 CET

Original text of this message