Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: extent size and segment size
Oracle does indeed round up to the nearest 5 blocks as stated below.
However, it only seems to do this if the extent is > that 5 blocks to begin
with.
i.e. If I have a 4k datablock and my initial is 16k (4 blocks), The
initial would be 16k and the bytes sould be 16k. This is also true for the
next extents. If my next extent is 16k, this is all that would be
allocated for each next extent (Assuming pctincrease is 0). if next extent
were 24k (8 blocks) then 40K will be allocated (10 blocks).
-- My views are my views! You can have your own. ___ O 0 (_/\_) 0 ====(o) o Kelly Young <young_at_maricopa.edu> wrote in article <32E7FB5D.2EB8_at_maricopa.edu>...Received on Fri Jan 24 1997 - 00:00:00 CST
> > Page size is 4K.
> > I can understand that 'INITIAL_EXTENT' is changed from 101k to
104k(106496bytes)
> > But I can't understand that 'BYTES' shows 122880 bytes ( 120k ).
>
> When Oracle allocates storage for an extent, it allocates in multiples
> of
> 5 oracle blocks. Your initial extent equated to 26 oracle blocks
> 106496 / 4096 = 26. Oracle rounded that to 30 blocks. 30 * 4096 =
> 122880.
>