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/ -- //www.freelists.org/webpage/oracle-l