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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: results of analyze

RE: results of analyze

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Wed, 29 Aug 2001 12:06:07 -0700
Message-ID: <F001.0037BD6C.20010829120034@fatcity.com>

> -----Original Message-----
> From: Ruth Gramolini [mailto:rgramolini_at_tax.state.vt.us]
>
> Someone asked me where the results of analying tables and
> indexes goes.† Can
> anyone tell me what table(s) holds the statistics generated.

I think this is a complete answer. If I've forgotten anything, please let me know, since this is the list I give out to people.

Sys views:††††††††††† Tables
dba_tables††††††††††† sys.tab$
dba_tab_columns†††††† sys.hist_head$

dba_tab_col_statistics

dba_tab_histograms††† sys.hist_head$

††††††††††††††††††††† sys.histgrm$


dba_tab_partitions††† sys.tabpart$

††††††††††††††††††††† sys.tabcompart$


dba_tab_subpartitions sys.tabsubpart$

dba_indexes†††††††††† sys.ind$

dba_ind_partitions††† sys.indpart$

††††††††††††††††††††† sys.indcompart$


dba_ind_subpartitions sys.indsubpart$

Jacques R. KilchoŽr
x8816> Received on Wed Aug 29 2001 - 14:06:07 CDT

Original text of this message

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