Re: cursor_sharing setting
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Mon, 10 Feb 2020 12:11:23 -0500
Message-ID: <140e5d01-f5d8-4897-b0e5-5495da0a8f42_at_gmail.com>
Date: Mon, 10 Feb 2020 12:11:23 -0500
Message-ID: <140e5d01-f5d8-4897-b0e5-5495da0a8f42_at_gmail.com>
I would not set it anywhere. CS = FORCE is a source of many optimizer
bugs and is only recommended in case of an emergency, where one needs to
break the glass first.
Regards
On 2/10/20 7:54 AM, l.flatz_at_bluewin.ch wrote:
> Hi,
>
> I would not set cs=forced in a DWH. These a logrunning queries and the
> plans should be as good as possible.
> Parse time will normally be a lesser concern.
> Just to give an example: Bind varaibles for a partition key should
> inhibit from partion stats being used on parsing.
>
> Regards
>
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Feb 10 2020 - 18:11:23 CET