Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: why five (blocks)?
You've answered how the 5 blocks are allocated. Can you answer why
there are four datablocks?
L
Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl> wrote in message news:<r44hkvsbodp0nkvcvtv8dct4cjkoaaej4m_at_4ax.com>...
> On Sun, 24 Aug 2003 13:07:25 +0300, "Tanel Poder"
> <change_to_my_first_name_at_integrid.info> wrote:
>
> >Hi!
> >
> >I've always wondered why the minimum number of blocks in an extent was
> >rounded to nearest higher multiple of 5 oracle blocks in earlier server
> >versions?
> >Nowadays this isn't an issue anymore, but I'm just wondering where does this
> >magic number 5 come from?
> >
> >Tanel.
> >
>
> one header block + 4 data blocks
>
> (So it would make sense for the first extent only)
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Mon Aug 25 2003 - 14:55:50 CDT
![]() |
![]() |