Question about statistic and dba_tab_modifications
Hello,
Context: 10gR2, schema XXXX
Scenario: - Table tt empty - Insert x rows in tt - num_rows still null for tt in dba_tables - dba_tab_modifications empty for tt ("exec DBMS_STATS.FLUSH_DATABASE_MONITORING_INFO" not done) - rebounce database - Insert y rows in tt - exec dbms_stats.gather_table_stats ('<owner>', ‘TT’) ==> num_rows = x + y for tt in dba_tables Question: As dba_tab_modifications has not been updated before rebounce and all information of the SGA are lost during shutdown, where oracle may find information about inserts? Just count(*) ?? Thanks in advance, Armel0