Database Administration (MOSC)

MOSC Banner

Question about statistic and dba_tab_modifications

edited May 30, 2011 12:05AM in Database Administration (MOSC) 7 commentsAnswered
 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, Armel

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center