dbms_stats.gather_schema_stats problem
ski123Feb 18 2009 — edited Feb 18 2009Oracle 9.2. We run this stats each day:
exec dbms_stats.gather_schema_stats(OWNNAME=>'MD', ESTIMATE_PERCENT=> dbms_stats.auto_sample_size,METHOD_OPT=> 'FOR ALL COLUMNS SIZE AUTO',GRANULARITY => 'ALL',CASCADE => TRUE,OPTIONS=> 'GATHER AUTO');
See following table DM_PRICE_REPORT, why didn't it get analyzed?
OWNER TABLE_NAME SAMPLE_SIZE NUM_ROWS LAST_ANALYZED
DM DM_PRICE_REPORT 67722 6772200 12/10/2008 6:35:30 PM
Is Sample_SIZE problem?
Please advise.
S.