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.gathered_table_stats shows num_rows=0 for 12gb table.

shaileshJun 28 2011 — edited Jun 28 2011

Hi,

I am having a table of 12GB in size having count(*) in crores. But after gathering the stats from dbms_stats proc, the statistics i saw in user_tables and user_tab_statistics for this table are num_rows=0, blocks=0, sample_size=0.

I am not getting understand why it behave like this. Even for indexes of this table are showing zero stats.

Please help.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 26 2011

Added on Jun 28 2011

#general-database-discussions

6 comments

670 views