Re: Trigger SMON to dump table statistics to ALL_TAB_MODIFICATIONS

  • From: Bala <oratips@xxxxxxxxx>
  • To: rjamya@xxxxxxxxx
  • Date: Wed, 6 Jun 2007 14:25:05 -0400

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

Other related posts: