Re: Analyze with estimate

       Hi,
       1) When you analyze tables the information is usually in
       dba_tables / user_tables
            The columns are
             EMPTY_BLOCKS
            AVG_SPACE
            CHAIN_CNT
            AVG_ROW_LEN


                 Hope this helps.


                           shreepad



       From: ORACLE-L_at_fatcity.com AT INTERNET on 07/03/2000 03:38 PM

       To:   ORACLE-L_at_fatcity.com AT INTERNET_at_CCMAIL
       cc:    (bcc: Shreepad Vaidya/IN/ALLTELCORP)

       Subject:  Analyze with estimate


       Can somebody tell me specifically which dictionary/catalog
       columns are
       updated when I
       execute an "ANALYZE TABLE XXXXXXX  ESTIMATE STATISTICS SAMPLE
       10 PERCENT;"

       Or (better yet)  point me to the documentation that defined
       same?

       Thanks.



       ?????????

       --
       Author:
         INET: Dan.Hubler_at_midata.com

       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_at_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