Query the DBA_SEGMENTS table for the blocks column. The segment_name column
will match the index name. The SEGMENT_TYPE column should also have the
value of 'INDEX'.
> -----Original Message-----
> From: ALEMU Abiy [SMTP:abiy.alemu_at_criltechnology.com]
> Sent: Wednesday, May 03, 2000 8:56 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Actual index sizes
>
> I would like to know which system table to consult to know the actual size
> of an index. Can you please correct me if I'm mistaken by saying that the
> size of an index varies with respect to the number of rows in the the
> table
> ?
>
> I need your help friends !!!
> --
> Author: ALEMU Abiy
> INET: abiy.alemu_at_criltechnology.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 subscribing).
Received on Wed May 03 2000 - 14:13:56 CDT
