Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Rebuild indexes
If you look at Stephens post, then a reduction from free space of 30%
in the blocks to 10% in the blocks (assuming pctfree =3D 10), gives
around 20% gain back or around 800m from a 4G index. This would fit
in quite nicely with what you are observing.
hth
connor
On 5/23/05, Peter Dixon <peterdixon001_at_hotmail.com> wrote:
> I have an application where data is never deleted, I have just rebuilt an
> index which was previously 4gb in size and its now 3gb in size. Can anybo=
dy
> explain?
>=20 >=20
--=20
Connor McDonald
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D
email: connor_mcdonald_at_yahoo.com
web: http://www.oracledba.co.uk
"Semper in excremento, sole profundum qui variat"
-- http://www.freelists.org/webpage/oracle-lReceived on Mon May 23 2005 - 04:35:13 CDT
![]() |
![]() |