Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Trigger SMON to dump table statistics to ALL_TAB_MODIFICATIONS
Thank you very much for all the responses and for the 'Case study' below.
I asked the question since before running the procedure query on
all_tab_modifications returned rows and after the procedure execution none
were returned.
so "Flush" is rather a "Push".
:-) thanks
Bala --
On 6/6/07, Alexander Fatkulin <afatkulin_at_gmail.com> wrote:
>
> 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 -
> >
> >
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jun 06 2007 - 14:13:09 CDT