Re: Trigger SMON to dump table statistics to ALL_TAB_MODIFICATIONS

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_at_gmail.com> 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_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

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