Re: Stats gathering (8i) to non-data dictionary tables

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 2 Aug 2005 07:46:51 -0700
Message-ID: <1122994011.125134.19960@z14g2000cwz.googlegroups.com>

Mike, try looking again and look at the stattab entry >>

DBMS_STATS.GATHER_TABLE_STATS (

   ownname          VARCHAR2,
   tabname          VARCHAR2,
   partname         VARCHAR2 DEFAULT NULL,
   estimate_percent NUMBER   DEFAULT NULL,
   block_sample     BOOLEAN  DEFAULT FALSE,
   method_opt       VARCHAR2 DEFAULT 'FOR ALL COLUMNS SIZE 1',
   degree           NUMBER   DEFAULT NULL,
   granularity      VARCHAR2 DEFAULT 'DEFAULT',
   cascade          BOOLEAN  DEFAULT FALSE,
   stattab          VARCHAR2 DEFAULT NULL,
   statid           VARCHAR2 DEFAULT NULL,
   statown          VARCHAR2 DEFAULT NULL);

>> User stat table identifier describing where to save the current statistics <<

(Everybody misses stuff now and then)
HTH -- Mark D Powell -- Received on Tue Aug 02 2005 - 09:46:51 CDT