From NDATFM@labor.state.ny.us Wed, 29 Aug 2001 07:01:48 -0700 From: "Mercadante, Thomas F" Date: Wed, 29 Aug 2001 07:01:48 -0700 Subject: RE: results of analyze Message-ID: MIME-Version: 1.0 Content-Type: text/plain Ruth, the results are stored in the USER_TABLES and USER_INDEXES views. below are some of the columns that get populated when I issue the following command: dbms_stats.gather_table_stats('schemaname','tablename'); hope this helps 09:28:15 WTWD> descr user_tables Name ------------------------------- NUM_ROWS <= BLOCKS <= EMPTY_BLOCKS <= AVG_SPACE <= CHAIN_CNT <= AVG_ROW_LEN <= AVG_SPACE_FREELIST_BLOCKS <= NUM_FREELIST_BLOCKS <= SAMPLE_SIZE <= LAST_ANALYZED <= 09:28:18 WTWD> descr user_indexes Name -------------------------------------- BLEVEL <= LEAF_BLOCKS <= DISTINCT_KEYS <= AVG_LEAF_BLOCKS_PER_KEY <= AVG_DATA_BLOCKS_PER_KEY <= NUM_ROWS <= SAMPLE_SIZE <= LAST_ANALYZED <= Tom Mercadante Oracle Certified Professional -----Original Message----- Sent: Wednesday, August 29, 2001 9:41 AM To: Multiple recipients of list ORACLE-L Good morning all, Someone asked me where the results of analying tables and indexes goes. Can anyone tell me what table(s) holds the statistics generated. Thanks, Ruth B. Gramolini ORACLE & DB2 DBA VT Dept. of Taxes ph# 802.828.5708 fax# 802.828..3754 rgramolini@tax.state.vt.us -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: rgramolini@tax.state.vt.us Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: NDATFM@labor.state.ny.us Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).