Re: why five (blocks)?

From: Svend Jensen <svend.s.jensen_at_it.dk>
Date: Sun, 24 Aug 2003 18:57:32 +0200
Message-ID: <3f48ee68$0$32531$edfadb0f@dread16.news.tele.dk>

Tanel Poder 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.
>
>

Default extent size was 10k (se your sql.bsq in $ORACLE_HOME/rdbms/admin) and default db_blocksize was 2K, that makes 5 extents of 2K each.

rgds

/Svend

PS: remove the spamkiller [s.] in reply address Received on Sun Aug 24 2003 - 11:57:32 CDT