DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
        b=C88caEycl+YYwJYvFDs85bcOJa54A19D4whbltHHhmlEWNWVSEGSDR/1YLWNfJsO8E2e7Pra/qZZrW44+A9Gtx4jn86wdFGwAUjwWB9ECQBF4rK417CMXAfcrrCAdVEk6X4O8H/9LaQXRDJgCt7JYznStywHrD7tLfrtFqlw8Yk=
Message-ID: <9ea7ad870706061213l301be4edi5f1a746900d34e31@mail.gmail.com>
Date: Wed, 6 Jun 2007 15:13:09 -0400
From: Bala <oratips@gmail.com>
To: "Alexander Fatkulin" <afatkulin@gmail.com>
Subject: Re: Trigger SMON to dump table statistics to ALL_TAB_MODIFICATIONS
Cc: oracle-l@freelists.org
In-Reply-To: <49d668000706061207j55c880b0rac3a2c3af1eb89de@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_Part_41232_19490473.1181157189588"
References: <357b48a90706060939h26b72de4reb34ba34d37ff599@mail.gmail.com>
	 <9177895d0706061103v76127d7bw3e1884dfef3ffce8@mail.gmail.com>
	 <9ea7ad870706061125p75959be6ja816d0d4fa897848@mail.gmail.com>
	 <49d668000706061207j55c880b0rac3a2c3af1eb89de@mail.gmail.com>
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: oratips@gmail.com
------=_Part_41232_19490473.1181157189588
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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@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@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 -
> >
> >
>

------=_Part_41232_19490473.1181157189588
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div>Thank you very much for all the responses and for the &#39;Case study&#39; below. </div>
<div>I asked the question since before running the procedure query on all_tab_modifications returned rows and after the procedure execution none were returned.</div>
<div>&nbsp;</div>
<div>so &quot;Flush&quot; is rather a &quot;Push&quot;. </div>
<div>&nbsp;</div>
<div>:-) thanks</div>
<div>&nbsp;</div>
<div>Bala --</div>
<div><br><br>&nbsp;</div>
<div><span class="gmail_quote">On 6/6/07, <b class="gmail_sendername">Alexander Fatkulin</b> &lt;<a href="mailto:afatkulin@gmail.com">afatkulin@gmail.com</a>&gt; wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Have you enabled monitoring on that table?<br><br>SQL&gt; create table test (n number);<br><br>Table created.
<br><br>SQL&gt; alter table test monitoring;<br><br>Table altered.<br><br>SQL&gt; insert into test values (1);<br><br>1 row created.<br><br>SQL&gt; commit;<br><br>Commit complete.<br><br>SQL&gt; select inserts<br>2&nbsp;&nbsp;&nbsp;&nbsp; from user_tab_modifications
<br>3&nbsp;&nbsp;&nbsp;&nbsp; where table_name=&#39;TEST&#39;;<br><br>no rows selected<br><br>SQL&gt; exec dbms_stats.flush_database_monitoring_info;<br><br>PL/SQL procedure successfully completed.<br><br>SQL&gt; select inserts<br>2&nbsp;&nbsp;&nbsp;&nbsp; from user_tab_modifications
<br>3&nbsp;&nbsp;&nbsp;&nbsp; where table_name=&#39;TEST&#39;;<br><br>&nbsp;&nbsp;INSERTS<br>----------<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1<br><br>On 6/6/07, Bala &lt;<a href="mailto:oratips@gmail.com">oratips@gmail.com</a>&gt; wrote:<br>&gt; If we insert/delete/update/truncate a table and than do
<br>&gt; step 1) exec dbms_stats.flush_database_monitoring_info<br>&gt;<br>&gt; step 2) select * from all_tab_modifications<br>&gt;<br>&gt; zero rows returned ? since we are &quot;flushing&quot; the monitoring info ?<br>&gt;
<br>&gt; Thanks in advance<br>&gt; bala -<br>&gt;<br>&gt;<br>&nbsp;</blockquote></div>

------=_Part_41232_19490473.1181157189588--
--
http://www.freelists.org/webpage/oracle-l