Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Trigger SMON to dump table statistics to ALL_TAB_MODIFICATIONS

Re: Trigger SMON to dump table statistics to ALL_TAB_MODIFICATIONS

From: Tim Gorman <tim_at_evdbt.com>
Date: Wed, 06 Jun 2007 11:48:27 -0600
Message-ID: <4666F36B.2020505@evdbt.com>


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-l
Received on Wed Jun 06 2007 - 12:48:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US