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: Alexander Fatkulin <afatkulin_at_gmail.com>
Date: Wed, 6 Jun 2007 13:03:30 -0400
Message-ID: <49d668000706061003k2d10fa24jcdfce6892747eed4@mail.gmail.com>


There is - dbms_stats.flush_database_monitoring_info

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

-- 
Alexander Fatkulin
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jun 06 2007 - 12:03:30 CDT

Original text of this message

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