FLUSH_DATABASE_MONITORING_INFO Procedure

FLUSH_DATABASE_MONITORING_INFO Procedure


A FLUSH_DATABASE_MONITORING_INFO is Procedure in DMBS_STATS package. 
This procedure flush monitoring information for all tables. Corresponding entries in the *_TAB_MODIFICATIONS, *_TAB_STATISTICS and *_IND_STATISTICS views are updated immediately.
SQL> update tb_obj set object_id=100 where rownum <= 50; 

50 rows updated. 

SQL> commit;

Commit complete.

SQL> select table_name, inserts, updates, deletes from user_tab_modifications;

TABLE_NAME INSERTS UPDATES DELETES
------------------------------ ---------- ---------- ----------
TB_OBJ           0     0       1

SQL> delete from tb_obj where rownum <= 50; 50 rows deleted. SQL> commit;

Commit complete.

SQL> select table_name, inserts, updates, deletes from user_tab_modifications;

TABLE_NAME INSERTS UPDATES DELETES
------------------------------ ---------- ---------- ----------
TB_OBJ         0      0        1
Test to use FLUSH_DATABASE_MONITORING_INFO Procedure:

SQL> exec dbms_stats.FLUSH_DATABASE_MONITORING_INFO;

PL/SQL procedure successfully completed.

SQL> select table_name, inserts, updates, deletes from user_tab_modifications;

TABLE_NAME INSERTS UPDATES DELETES
------------------------------ ---------- ---------- ----------
TB_OBJ        0        50      51

That shows monitoring information after it's flushed from memory.