Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: 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.
In article <O0c6S5hO$GA.271_at_cpmsnbbsa02>,
"Joe Ramsey" <OracleWiz_at_msn.com> wrote:
> 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
>
> ramseyj_at_cintasmail.com
>
>
--
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.
Received on Mon Nov 29 1999 - 09:07:38 CST