0 Replies Latest reply on Jul 24, 2013 8:24 PM by dmg2012



      Hi All,


      Is 11g : DBMS_STATS.AUTO_SAMPLE_SIZE will default to 100%  for Oracle 11g ?


      Will the time taken for AUTO and 100% are both equal for Oracle 11g ?


      Doc ID -  605439.1


      Note - Note that on 11g, although using auto size for ESTIMATE_PERCENT tends to default to 100% ,because this is an auto sample, the engine may still decide to use a different sample size for tables and columns.  This means that Column statistics could still be gathered with a small sample size and create a histogram that is missing key values. When ESTIMATE_PERCENT is set to a specific numeric value, that value will be used for both the table and columns.