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