Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

dbms_stats.gather_schema_stats problem

ski123Feb 18 2009 — edited Feb 18 2009
Oracle 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 18 2009
Added on Feb 18 2009
6 comments
310 views