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.