Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> DBMS_STATS gather stale option

DBMS_STATS gather stale option

From: Gail Binkley <gail_at_alberich.Stanford.EDU>
Date: Mon, 28 Oct 2002 21:32:17 +0000 (UTC)
Message-ID: <apkad1$6mj$1@news.Stanford.EDU>


I use DBMS_STATS to gather statistics for all tables in an Oracle 8.1.7.3 database. I would like use the GATHER STALE option of GATHER_SCHEMA_STATS to automatically collect statistics. However, the tables in this database vary widely in size and there is also a partitioned table.

If I execute DBMS_STATS.GATHER_SCHEMA_STATS with the GATHER STALE option, will it gather statistics based on how statistics were gathered previously on each table (compute, estimate, and partition), or will it compute statistics on all tables no matter the type or size of the table? There is no GATHER STALE option associated with GATHER_TABLE_STATS. Thanks for your help.

Gail


-- 
Department of Genetics        Phone: (650) 498-7145
School of Medicine              Fax: (650) 723-7016
Stanford University           Email: gail_at_genome.stanford.edu
Stanford, CA 94305-5120         URL: http://genome-www.stanford.edu/
Received on Mon Oct 28 2002 - 15:32:17 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US