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
>>> [EMAIL PROTECTED] 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)" <[EMAIL PROTECTED]> 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 - [EMAIL PROTECTED] > 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)" <[EMAIL PROTECTED]> > 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 - [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
