From oracle-l-bounce@freelists.org Thu Jan 6 02:22:42 2005 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id j068MfW21964 for ; Thu, 6 Jan 2005 02:22:41 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id j068Mfn21958 for ; Thu, 6 Jan 2005 02:22:41 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8ADE072C354; Thu, 6 Jan 2005 03:29:15 -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 25016-73; Thu, 6 Jan 2005 03:29:15 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 704FC72C6AE; Thu, 6 Jan 2005 03:27:53 -0500 (EST) Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; b=2DjGbv0RuxRSvykGZLB6dh0f0j4dp5srA7qj23rcvXKaHzyH6M0YgMbeWiHyA1Xoq1AxaIPY1F0rnguEBGmBudkNuPLdr7ywFQ2zmJgXkFSoDE2R6QkIGbChFnH2QEUIVYuITi/4ZDwvkPXLTB+i90TG37VRrBPO7nS5xeEdgkM= ; Message-ID: <20050106082438.98554.qmail@web80906.mail.scd.yahoo.com> Date: Thu, 6 Jan 2005 00:24:38 -0800 (PST) From: Ravi B Subject: Re: Statsitics information with DBMS_STATS To: breitliw@centrexcc.com Cc: oracle-l@freelists.org In-Reply-To: <6.1.0.6.2.20041231065440.0359ac58@pop.centrexcc.com> MIME-Version: 1.0 Content-type: text/plain Content-Transfer-Encoding: 8bit X-archive-position: 14415 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: ravi4ora@yahoo.com Precedence: normal Reply-To: ravi4ora@yahoo.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org dbms_stats.gather_table_stats(NULL,'SL_ING_SL',estimate_percent=>15); Wolfgang Breitling wrote:Then you're doing something wrong. What is the exact dbms_stats procedure call you are using? At 04:50 AM 12/31/2004, Ravi B wrote: >Which data dictionary table will get updated after the generation of >statistics with DBMS_STATS package in Oracle 9i. The column last_analyzed in > >dba_tables is not getting updated after generating statistics with >dbms_stats. Where do I check this information. Regards Wolfgang Breitling Centrex Consulting Corporation www.centrexcc.com -- http://www.freelists.org/webpage/oracle-l --------------------------------- Do you Yahoo!? Yahoo! Mail - Find what you need with new enhanced search. Learn more. -- http://www.freelists.org/webpage/oracle-l