RE: rebuilding indexes

From: Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>
Date: Fri, 31 May 2002 09:23:31 -0800
Message-ID: <F001.004711DB.20020531092331@fatcity.com>

But when you rebuild, it will reestablish the pctfree in all of the index blocks. If you had a lot of activity this free space would have been used in the original index and is now reclaimed.

Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority 1240 W. 6th Street
Cleveland, Ohio 44113
(216) 781-4204

>>> MATT.ADAMS_at_APPL.GE.COM 5/31/02 1:11:54 PM >>> 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). 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jeffrey Beckstrom
  INET: JBECKSTROM_at_gcrta.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 - 12:23:31 CDT