STALE STATISTICS on RAC 10.2?
Version: Oracle RAC 10.2.0.4 64bits.
The num_rows in dba_tables for a particular table was in 48 millions. However, if we do a count(*) the table only has 3.5millions. We tried to refresh the statistics first with analyze table and the with dbms_stats.gather_schema_stats but in both cases after finishing the execute, the view still shows 48 millions. We deleted 1 millions of unused rows again performed the analyze, in this case the num_rows columns showed 35 millions. Finally, after perform an dbms_stat.delete_schemas_stats and
The num_rows in dba_tables for a particular table was in 48 millions. However, if we do a count(*) the table only has 3.5millions. We tried to refresh the statistics first with analyze table and the with dbms_stats.gather_schema_stats but in both cases after finishing the execute, the view still shows 48 millions. We deleted 1 millions of unused rows again performed the analyze, in this case the num_rows columns showed 35 millions. Finally, after perform an dbms_stat.delete_schemas_stats and
0