Go to the FreeLists Home Page Home Signup Help Login
 



[oracle-l] || [Date Prev] [06-2007 Date Index] [Date Next] || [Thread Prev] [06-2007 Thread Index] [Thread Next]

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






[ Home | Signup | Help | Login | Archives | Lists ]

All trademarks and copyrights within the FreeLists archives are owned by their respective owners.
Everything else ©2007 Avenir Technologies, LLC.