Non Stale Statisics
i have a table with the following statistics :
num_rows :352000
last analyzed :12.12.08.
However if i issued : select count(*) from mytable ;
i have 850000 rows.
I have checked the DBA_TAB_MODIFICATIONS view i found :
inserts :10790 ,update :zero,delets :zero, timestamp:12.12.08
I did execute DBMS_STATS.FLUSH_DATABASE_MONITORING_INFO;
then i have :
inserts :10810 ,update :zero,delets :zero, timestamp:12.12.08 .
My question is : How can the inserts in the table -500000-record are not reflected in the view and hence the automated gathering job is not capturing this table ?
Oracle 10g,SE,10.2.3.0.
this database was upgraded from 9i.
Best wishes