From oracle-l-bounce@freelists.org Tue Nov 22 06:34:20 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id jAMCYKhW014931 for ; Tue, 22 Nov 2005 06:34:20 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id jAMCYEAX014912 for ; Tue, 22 Nov 2005 06:34:14 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A330D23358C; Tue, 22 Nov 2005 07:34:10 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 15780-06; Tue, 22 Nov 2005 07:34:10 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2ABCC23341B; Tue, 22 Nov 2005 07:34:10 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 22 Nov 2005 07:32:14 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B2FDB2332B9 for ; Tue, 22 Nov 2005 07:32:14 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 15437-03 for ; Tue, 22 Nov 2005 07:32:14 -0500 (EST) Received: from xproxy.gmail.com (xproxy.gmail.com [66.249.82.198]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8BCA12332B3 for ; Tue, 22 Nov 2005 07:32:14 -0500 (EST) Received: by xproxy.gmail.com with SMTP id s6so1006640wxc for ; Tue, 22 Nov 2005 04:32:14 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=tXK3L1fxGzgsIey+nh9OhMShibxpUsIS1nG39NjXK3INrMtpbOGHwzHgmIn0hwJ4pn2YglC6ev2Gmo58ItqVW50YoCacijB/mJWPgwHIwoYc5ztOuzhI/aiiF6YjPInhNVdTGKiNFJZA4DW9judfbTEixnYPZZirQ8E2RtelwKU= Received: by 10.70.15.17 with SMTP id 17mr2464269wxo; Tue, 22 Nov 2005 04:32:14 -0800 (PST) Received: by 10.70.131.5 with HTTP; Tue, 22 Nov 2005 04:32:14 -0800 (PST) Message-ID: Date: Tue, 22 Nov 2005 08:32:14 -0400 From: Juan Carlos Reyes Pacheco To: =?ISO-8859-1?Q?Mogens_N=F8rrgaard?= Subject: Re: Which is the frequency to execute GATHER_DICTIONARY_STATS & GATHER_FIXED_OBJECTS_STATS Cc: John.Hallas@gb.vodafone.co.uk, oracle-l@freelists.org In-Reply-To: <4382F803.9020507@miracleas.dk> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis Content-Disposition: inline References: <1C6E45ADB2EC324F9553E468ABFE0F63030F10CF@UKWMXM04> <4382F803.9020507@miracleas.dk> X-archive-position: 28573 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: juancarlosreyesp@gmail.com Precedence: normal Reply-To: juancarlosreyesp@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-4.0 required=5.0 tests=AWL,BAYES_00, RCVD_IN_BL_SPAMCOP_NET autolearn=no version=2.63 Mogens, I understand the advice is to trace, this means gather statistics now and trace now, and every month for example and see if execution plans goes worst, if they goes worst then is time to gather statistics again? Thank you :) -- http://www.freelists.org/webpage/oracle-l