Re: How to discard the statistics on tables and indexes?

From: Darrell Landrum <darrell_at_landrum.com>
Date: Wed, 24 Mar 2004 23:14:43 -0600
Message-ID: <00ff01c41228$1579eb80$6701a8c0@darrell1>

Delete them using Oracle supplied procedures:

DELETE_TABLE_STATS Procedure
This procedure deletes table-related statistics.

Syntax
DBMS_STATS.DELETE_TABLE_STATS (

   ownname         VARCHAR2,
   tabname         VARCHAR2,
   partname        VARCHAR2  DEFAULT NULL,
   stattab         VARCHAR2  DEFAULT NULL,
   statid          VARCHAR2  DEFAULT NULL,
   cascade_parts   BOOLEAN   DEFAULT TRUE,

   cascade_columns BOOLEAN DEFAULT TRUE,    cascade_indexes BOOLEAN DEFAULT TRUE,    statown VARCHAR2 DEFAULT NULL,    no_invalidate BOOLEAN DEFAULT FALSE); There's also a delete_index_stats, but this one appears to take care of the index stats as well with the cascade_indexes argument.----- Original Message -----
From: <chuan.zhang_at_customs.gov.au>
To: <oracle-l_at_freelists.org>
Sent: Wednesday, March 24, 2004 10:47 PM Subject: How to discard the statistics on tables and indexes?

> 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_at_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
> -----------------------------------------------------------------
>

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_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
-----------------------------------------------------------------

Received on Wed Mar 24 2004 - 23:11:17 CST