FreeLists / oracle-l / Re: Trigger SMON to dump table statistics to ALL_TAB_MODIFICATIONS

[Bala <oratips@xxxxxxxxx>]

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