Re: Percent Increase Behavior

Oracle rounds by 5's not by one block. That is Oracle likes to make the extent an even muultiple of 5, but the exact amount of space used depends on the size of the freespace extent that is used to allocate the space for the extent and how much is left after subtracting the requested amount. If the amount of space left in the free space extents is under 5 blocks it is usually added to your request.

Look in the database administrators guide in the section on index space allocation to find this.

Hope this helps.
Mark Powell -- The only advise that counts is the advise that you follow so follow your own advise Received on Fri Mar 07 1997 - 00:00:00 CST