From oracle-l-bounce@freelists.org Wed Mar 24 22:53:56 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2P4ru419579 for ; Wed, 24 Mar 2004 22:53:56 -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 i2P4ruo19574 for ; Wed, 24 Mar 2004 22:53:56 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 310D6390FE5; Wed, 24 Mar 2004 23:51:23 -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 23349-33; Wed, 24 Mar 2004 23:51:23 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6EB4A390D14; Wed, 24 Mar 2004 23:51:22 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 24 Mar 2004 23:50:07 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4DA57390FCC for ; Wed, 24 Mar 2004 23:50:06 -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 22278-84 for ; Wed, 24 Mar 2004 23:50:06 -0500 (EST) Received: from lion.sge.net (lion.sge.net [152.91.9.63]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 766F2390FB3 for ; Wed, 24 Mar 2004 23:50:05 -0500 (EST) Received: from virusscan04.sge.net (crown.sge.net [152.91.9.100]) by lion.sge.net (Postfix) with ESMTP id 692CA187B0 for ; Thu, 25 Mar 2004 15:57:17 +1100 (EST) Received: by virusscan04.sge.net (Postfix, from userid 0) id 2D1499639B; Thu, 25 Mar 2004 15:57:20 +1100 (EST) Received: from castleman.sge.net (localhost.localdomain [127.0.0.1]) by virusscan04.sge.net (Postfix) with ESMTP id 02D3E9E222 for ; Thu, 25 Mar 2004 15:57:20 +1100 (EST) Received: by castleman.sge.net (Postfix, from userid 5) id CF59C7361A; Thu, 25 Mar 2004 15:57:16 +1100 (EST) Received: from nodnsquery(162.145.97.16) by castleman.sge.net via csmap (V6.0) id srcAAAh8aaiv; Thu, 25 Mar 04 15:57:15 +1100 Received: from aubwdmcust001.customs.gov.au (aubwdmcust001.customs.gov.au) by aubwdmcust000.customs.gov.au (Content Technologies SMTPRS 4.3.6) with ESMTP id for ; Thu, 25 Mar 2004 16:02:07 +1100 Received: by aubwdmcust001.customs.gov.au with Internet Mail Service (5.5.2653.19) id ; Thu, 25 Mar 2004 15:56:56 +1100 Message-ID: <74D7B90CA0FCF64FB2DADCA82F2D9434030FA1FD@auactmcust102.customs.gov.au> From: chuan.zhang@customs.gov.au To: oracle-l@freelists.org Subject: How to discard the statistics on tables and indexes? Date: Thu, 25 Mar 2004 15:47:26 +1100 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: text/plain; charset="iso-8859-1" X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 1737 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: chuan.zhang@customs.gov.au Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Hi, All, Our database is CBO based. I would like to see what's going on without those collected statistics on tables and indexes. Is there any way to discard these collected statistics? TIA, Important: This transmission is intended only for the use of the addressee and may contain confidential or legally privileged information. If you are not the intended recipient, you are notified that any use or dissemination of this communication is strictly prohibited. If you receive this transmission in error please notify the author immediately by telephone and delete all copies of this transmission together with any attachments. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------