Need Help With Index Rebuild 
Author Message
 Need Help With Index Rebuild

I have taken over several Oracle 7.3.4 databases.  There are a number of
indexes that were created with
something like INITIAL 110M NEXT 1M PCTINCREASE 0.

The DBA decided to change next to 20M to slow down the rate at which
segments are being created.
Performace isn't too big of an issue since these databases are being phased
out.  The extents are almost
full and I want to rebuild the index and size it correctly.  There are
currently 250 segments used.  Is there
any way I can determine how large each of the segments belonging to this
index are so I can get a good
estimate of how much INITIAL and NEXT should be?

Thanks,

Joe Ramsey
Database Administrator
Cintas Corporation




Wed, 18 Jun 1902 08:00:00 GMT
 Need Help With Index Rebuild

Joe, you can look at DBA_SEGMENTS to get the total allocated size and
number of extents on an object.  You can look at SYS.DBA_EXTENTS to see
all the allocated extents for an object.

I hope this is what you wanted.



Quote:
> I have taken over several Oracle 7.3.4 databases.  There are a number
of
> indexes that were created with
> something like INITIAL 110M NEXT 1M PCTINCREASE 0.

> The DBA decided to change next to 20M to slow down the rate at which
> segments are being created.
> Performace isn't too big of an issue since these databases are being
phased
> out.  The extents are almost
> full and I want to rebuild the index and size it correctly.  There are
> currently 250 segments used.  Is there
> any way I can determine how large each of the segments belonging to
this
> index are so I can get a good
> estimate of how much INITIAL and NEXT should be?

> Thanks,

> Joe Ramsey
> Database Administrator
> Cintas Corporation



--
Mark D. Powell  -- The only advice that counts is the advice that
 you follow so follow your own advice --

Sent via Deja.com http://www.deja.com/
Before you buy.



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Difference in ranking results from a full index rebuild verses an incremental rebuild

2. rebuild or not rebuild index file, when ?, how?

3. Need Script in order to rebuild all indexes

4. Is there a need to rebuild indexes after bulk insert operation

5. Need 2 rebuild indexes??

6. Need procedure to rebuild a system index

7. Why do Table Indexes Need Rebuilding?

8. Indexes need to be rebuilt.

9. Help to Rebuild syscomments index

10. error rebuilding index help

11. locking during index rebuild making db unavailable -- please help

12. Help: Can't rebuild index from Sysindexes table


 
Powered by phpBB® Forum Software