We need to come up with a sample size for running DBMS_Stats.Gather tablestats procedure. The tables on which stats need to be collected are very large (Some of the tables are more than 25 G with the largest table being 95 G and has 600 million rows). How to come to a reasonable sample size for estimate. Would you recommend Auto sample size. We use a sample size of 4 for large tables as a general rule (in this environment). Completion time of the stats gathering is a factor in this calculation.
Thanks and Regards,