0 Replies Latest reply: Jul 24, 2013 3:24 PM by dmg2012 RSS

    11g : DBMS_STATS.AUTO_SAMPLE_SIZE

    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.