dbms_stats job
1.We have a dbms_stats job that runs for hours (> 3hrs)
2.We change the parameter from ESTIMATE_PERCENT => DBMS_STATS.AUTO_SAMPLE_SIZE to ESTIMATE_PERCENT => 5
3.When we set AUTO_SAMPLE_SIZE to AUTO then the script takes more than 3 hrs to collect the stats
Question ?
2.We change the parameter from ESTIMATE_PERCENT => DBMS_STATS.AUTO_SAMPLE_SIZE to ESTIMATE_PERCENT => 5
3.When we set AUTO_SAMPLE_SIZE to AUTO then the script takes more than 3 hrs to collect the stats
Question ?
1. Is there any way we can speed up the stats job to run faster ?
2. Is there any way we can collect the stats on only the partition that got changed instead of entire partition table ? The partition table is huge size of order 400 million rows for e.g. ?
3. Our stats program works on sys.dba_tab_modifications any tables that get recorded in this table are the ones on which stats will get collected.
0