Re: Trigger SMON to dump table statistics to ALL_TAB_MODIFICATIONS

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_at_gmail.com> wrote:
>
> EP,
>
> try exec dbms_stats.flush_database_monitoring_info;
>
> rjamya
>
> On 6/6/07, Ethan Post <post.ethan_at_gmail.com > wrote:
> >
> > Is there a way to force SMON to dump the most current table statistics
> > to all_tab_modifications?
> >
>
>
>

-- 
Bala Rao

--
http://www.freelists.org/webpage/oracle-l