Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Trigger SMON to dump table statistics to ALL_TAB_MODIFICATIONS
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_at_evdbt.com mobile = +1-303-885-4526 fax = +1-303-484-3608 -- http://www.freelists.org/webpage/oracle-lReceived on Wed Jun 06 2007 - 12:48:27 CDT