Re: Trigger SMON to dump table statistics to ALL_TAB_MODIFICATIONS

  • From: Tim Gorman <tim@xxxxxxxxx>
  • To: post.ethan@xxxxxxxxx
  • Date: Wed, 06 Jun 2007 11:48:27 -0600

DBMS_STATS.FLUSH_DATABASE_MONITORING_INFO

Ethan Post wrote:
Is there a way to force SMON to dump the most current table statistics to all_tab_modifications?

--
Tim Gorman
consultant - Evergreen Database Technologies, Inc.
P.O. Box 1802, Evergreen CO  80437-1802
website = http://www.evdbt.com
email   = tim@xxxxxxxxx
mobile  = +1-303-885-4526
fax     = +1-303-484-3608

--
http://www.freelists.org/webpage/oracle-l


Other related posts: