Re: Trigger SMON to dump table statistics to ALL_TAB_MODIFICATIONS

  • From: "K Gopalakrishnan" <kaygopal@xxxxxxxxx>
  • To: post.ethan@xxxxxxxxx
  • Date: Wed, 6 Jun 2007 10:44:14 -0700

Hi,

Use the DBMS_STATS.FLUSH_DATABASE_MONITORING_INFO();



On 6/6/07, Ethan Post <post.ethan@xxxxxxxxx> wrote:
Is there a way to force SMON to dump the most current table statistics to
all_tab_modifications?



--
Best Regards,
K Gopalakrishnan
Co-Author: Oracle Wait Interface, Oracle Press 2004
http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/

Author: Oracle Database 10g RAC Handbook, Oracle Press 2006
http://www.amazon.com/gp/product/007146509X/
--
http://www.freelists.org/webpage/oracle-l


Other related posts: