From oracle-l-bounce@freelists.org Thu Aug 25 13:46:09 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j7PIk9hV028059 for ; Thu, 25 Aug 2005 13:46:09 -0500 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 j7PIk5IP028042 for ; Thu, 25 Aug 2005 13:46:05 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9FDF51E629D; Thu, 25 Aug 2005 13:45:58 -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 05824-07; Thu, 25 Aug 2005 13:45:58 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 24B931E55C0; Thu, 25 Aug 2005 13:45:58 -0500 (EST) 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:references; b=RRCTxzZbtP/ifemwjDYcQOnFxQY3HIJ8kfvcQZXmF559o6CVmTvA1mOunYGgTr0d1io1fdtXmkTm8qL0Sh2eUgFVvtOJH3l7J+yhrH3FZY2L0KJQvo0y1JKMA7I/7M+HRqnBAjURgdSyJu27GokshuWQ1asLG/NnxIodqvzMGy4= Message-ID: Date: Thu, 25 Aug 2005 19:44:03 +0100 From: Jared Still To: gkatteri@fastmail.fm Subject: Re: dbms_stats now that we are at 9.2 Cc: oracle-l@freelists.org In-Reply-To: <430C906A.5060900@fastmail.fm> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_674_2298812.1124995443039" References: <52C70FF150F49E479DAF59C68A27149D0164C06B@va016a0e2.corp.suntrust.com> <430C906A.5060900@fastmail.fm> X-archive-position: 24506 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jkstill@gmail.com Precedence: normal Reply-To: jkstill@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-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-3.3 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE, NORMAL_HTTP_TO_IP autolearn=no version=2.63 ------=_Part_674_2298812.1124995443039 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline What kind of issues did you see with gather_schema_stats that could be rectified by using gather_table_stats? --=20 Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist On 8/24/05, GovindanK wrote: >=20 > We had issues with gather_schema_stats and we moved over to=20 > gather_table_states and since then have peace of mind(9.2.0.6);=20 > I have an build script that we are using in production which i will mail = you=20 > offline later today. >=20 > HTH > GovindanK ------=_Part_674_2298812.1124995443039 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline What kind of issues did you see with gather_schema_stats
that could be rectified by using gather_table_stats?


--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

On 8/24/05, GovindanK <gkatteri@fast= mail.fm> wrote:
=20 =20 We had issues with gather_schema_stats and we moved over to gather_table_states and since then have peace of mind(9.2.0.6); I have an build script that we are using in production which i will mail you offline later today.

HTH
GovindanK


------=_Part_674_2298812.1124995443039-- -- http://www.freelists.org/webpage/oracle-l