Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 13360 invoked from network); 6 Jun 2007 13:31:13 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 6 Jun 2007 13:31:13 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F2ABE6F1195; Wed, 6 Jun 2007 14:29:17 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 24706-10; Wed, 6 Jun 2007 14:29:17 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 797F36F0F04; Wed, 6 Jun 2007 14:29:17 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 06 Jun 2007 13:48:39 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A20116EF606 for ; Wed, 6 Jun 2007 13:48:39 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 19624-05 for ; Wed, 6 Jun 2007 13:48:39 -0400 (EDT) Received: from mx01.mailboxcop.com (mx01.mailboxcop.com [206.125.223.71]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6ECA96EF37A for ; Wed, 6 Jun 2007 13:48:39 -0400 (EDT) Received: from secure9.apollohosting.com (secure9.apollohosting.com [206.125.217.251]) by mx01.mailboxcop.com (8.13.1/8.13.1) with ESMTP id l56HoTn3031046 for ; Wed, 6 Jun 2007 12:50:30 -0500 Received: (qmail 25351 invoked from network); 6 Jun 2007 12:48:34 -0500 Received: from unknown (HELO ?127.0.0.1?) (tim@12.109.229.8) by secure9.apollohosting.com with ESMTPA; 6 Jun 2007 17:48:34 -0000 Message-ID: <4666F36B.2020505@evdbt.com> Date: Wed, 06 Jun 2007 11:48:27 -0600 From: Tim Gorman Organization: Evergreen Database Technologies, Inc. User-Agent: Thunderbird 2.0.0.0 (Windows/20070326) MIME-Version: 1.0 To: post.ethan@gmail.com CC: oracle-l Subject: Re: Trigger SMON to dump table statistics to ALL_TAB_MODIFICATIONS References: <357b48a90706060939h26b72de4reb34ba34d37ff599@mail.gmail.com> In-Reply-To: <357b48a90706060939h26b72de4reb34ba34d37ff599@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed X-Bayes-Prob: 0.0001 (Score 0) X-Spam-Score: 0.00 () [Hold at 6.00] X-CanItPRO-Stream: outgoing (inherits from default) X-Canit-Stats-ID: Bayes signature not available X-Scanned-By: CanIt (www . roaringpenguin . com) on 192.168.15.3 X-archive-position: 49522 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: tim@evdbt.com Precedence: normal Reply-to: tim@evdbt.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain 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@evdbt.com mobile = +1-303-885-4526 fax = +1-303-484-3608 -- http://www.freelists.org/webpage/oracle-l