Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: why five (blocks)?

Re: why five (blocks)?

From: Louis Frolio <froliol_at_yahoo.com>
Date: 25 Aug 2003 12:55:50 -0700
Message-ID: <94c28610.0308251155.7683f9e6@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US