Re: cursor_sharing setting

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
Lothar
----Ursprüngliche Nachricht----

Von : carlospena999_at_gmail.com
Datum : 07/02/2020 - 18:27 (MN)
An : oracle-l_at_freelists.org
Betreff : cursor_sharing setting
 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 Mon Feb 10 2020 - 13:54:47 CET