Mathew,
There has to be something that changed in the index or the storage
parameters. The index storage is basically based on the database block
size, the pctfree, the average length of the index entry, and the number
of rows in the index. If you changed none of these the index should
remain the same.
You said that each extend is 65 - 8K blocks and the increase was 5
extents. that's 2720 K of additional storage for the indexes. That is a
lot of rows of data to be indexing.
Are you sure that the information is correct? Did the 20 extent number
come from old records and there were a lot of additions to the data?
DID you analyze the indexes to create the extra space used?
Ron
ROR mª¿ªm
>>> wisernet100_at_yahoo.com 05/31/02 02:11PM >>>
then the only thing I can think of is that there was heavy activity on
the index prior to the rebuild and the blocks filled and the rebuild
evened it out.
- "Adams, Matthew (GEA, MABG, 088130)" <MATT.ADAMS_at_APPL.GE.COM>
wrote:
>
> storage parameter difference? None
>
> are you moving from one tablespace to
> another without specifying parameters? No
>
> pctfree/pctused influence? none
>
>
> I should have put this in the original message.
>
> Indexes stayed in original tablespace with identical
> storage parameters, but number of extents went from
> 20 to 25 (each extents is 65 8-K blocks)
> ----
> Matt Adams - GE Appliances - matt.adams_at_appl.ge.com
> Contrary to popular opinion, Unix is user friendly.
> It's just particular about who it makes friends with.
>
> -----Original Message-----
> Sent: Friday, May 31, 2002 12:49 PM
> To: Multiple recipients of list ORACLE-L
>
>
> storage parameter difference? are you moving from one tablespace to
> another without specifying parameters?
>
> pctfree/pctused influence?
>
>
> --- "Adams, Matthew (GEA, MABG, 088130)" <MATT.ADAMS_at_APPL.GE.COM>
> wrote:
> > Under what conditions would an 'alter index .. rebuild'
> > actually case the size of the index to increase
> > by about 12 percent?
> >
> >
> >
> > ----
> > Matt Adams - GE Appliances - matt.adams_at_appl.ge.com
> > Contrary to popular opinion, Unix is user friendly.
> > It's just particular about who it makes friends with.
> >
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! - Official partner of 2002 FIFA World Cup
> http://fifaworldcup.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rachel Carmichael
> INET: wisernet100_at_yahoo.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).
>
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Rogers
INET: RROGERS_at_galottery.org
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 Fri May 31 2002 - 14:32:02 CDT
