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
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ruth Gramolini
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
