Re: Percent Increase Behavior

From: Phil Cook <pcook_at_iamerica.net>
Date: 1997/03/05
Message-ID: <01bc290a$048b96c0$6cf9adcd@cookp.mo.chaparralsteel.com>#1/1

The size of the extent is a minimum of 5 times the block size to reduce fragmentation, so if you specify an extent of 4k with a block size of 2k, the extent will be created in 10k chunks.

Phil Cook

Medic Alert <news_at_medicalert.org> wrote in article <331C6BD1.26C8_at_medicalert.org>...
> According to Oracle's 7.x documentation, when
> the percent increase parameter of a storage
> clause is set to some non-zero value, after
> the second extent is allocated, the third
> extent should be the size of the second
> increased by pct_increase then rounded up
> to the next multiple of the database block
> size (usually 2K). In actuality, however,
> I have found that the number of bytes
> allocated is rounded up to the next
> multiple of 10K! I've checked this on
> instances running on 0S/2, VMS, and HP-UX
> and they all show the same behavior.
> Anyone else noticed this?
Received on Wed Mar 05 1997 - 00:00:00 CST