Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Trigger SMON to dump table statistics to ALL_TAB_MODIFICATIONS

Re: Trigger SMON to dump table statistics to ALL_TAB_MODIFICATIONS

From: rjamya <rjamya_at_gmail.com>
Date: Wed, 6 Jun 2007 14:03:58 -0400
Message-ID: <9177895d0706061103v76127d7bw3e1884dfef3ffce8@mail.gmail.com>


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

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jun 06 2007 - 13:03:58 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US