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