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!

NUM_ROWS not reflecting right amount of rows inside table

santiMar 15 2010 — edited Mar 15 2010

Hi,

We're using following command for analyzing our schemas for database 10.1.0.4:

exec DBMS_STATS.GATHER_SCHEMA_STATS (ownname =>'XXXX',estimate_percent=>30,cascade => TRUE,method_opt=>'FOR ALL COLUMNS SIZE 1' ,degree=>4);

After analyzing the NUM_ROWS column in dba_tables is not reflecting right number of rows for IOTs. Is it expected?

Regards,
Santi

This post has been answered by Santosh Kumar on Mar 15 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 12 2010

Added on Mar 15 2010

#general-database-discussions

7 comments

12,269 views