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 - On 6/6/07, rjamya <rjamya@xxxxxxxxx> wrote: > EP, > > try exec dbms_stats.flush_database_monitoring_info; > > rjamya > > > On 6/6/07, Ethan Post <post.ethan@xxxxxxxxx > wrote: > > Is there a way to force SMON to dump the most current table statistics to all_tab_modifications? > > > > > -- Bala Rao
-- Alexander Fatkulin -- //www.freelists.org/webpage/oracle-l