RE: Actual index sizes

Sorry, I missed the original message in this thread?

By size of the index, which of the following do you really mean?

1. Total space allocated
2. Total extents used
3. Actual space used inside the extents
4. Blocks available for insertion.

The answer for each is different.

Jared

On Wed, 3 May 2000, Elliott, Patrick wrote:

> 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).
> --
> Author: Elliott, Patrick
> INET: Patrick.Elliott_at_bestbuy.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).
>

Jared Still
Certified Oracle DBA and Part Time Perl Evangelist ;-) Regence BlueCross BlueShield of Oregon
jkstill_at_bcbso.com - Work - preferred address Received on Fri May 05 2000 - 11:37:28 CDT