Thank you very much for all the responses and for the 'Case study' below. I asked the question since before running the procedure query on all_tab_modifications returned rows and after the procedure execution none were returned. so "Flush" is rather a "Push". :-) thanks Bala -- On 6/6/07, Alexander Fatkulin <afatkulin@xxxxxxxxx> wrote:
Have you enabled monitoring on that table? SQL> create table test (n number); Table created. SQL> alter table test monitoring; Table altered. SQL> insert into test values (1); 1 row created. SQL> commit; Commit complete. SQL> select inserts 2 from user_tab_modifications 3 where table_name='TEST'; no rows selected SQL> exec dbms_stats.flush_database_monitoring_info; PL/SQL procedure successfully completed. SQL> select inserts 2 from user_tab_modifications 3 where table_name='TEST'; INSERTS ---------- 1 On 6/6/07, Bala <oratips@xxxxxxxxx> wrote: > If we insert/delete/update/truncate a table and than do > step 1) exec dbms_stats.flush_database_monitoring_info > > step 2) select * from all_tab_modifications > > zero rows returned ? since we are "flushing" the monitoring info ? > > Thanks in advance > bala - > >