Re: Next Extent?

From: Dick Allie <dallie_at_ionet.net>
Date: 1997/08/01
Message-ID: <33E24505.3806@ionet.net>#1/1

Luis Santos wrote:
>
> On Mon, 28 Jul 1997 16:31:59 +0100, Hanna LTEIF
> <hanna.lteif_at_infotechnique.com> wrote:
>
> >HI,
> >
> >I have this situation, i created a table with theses parameters:
> >
> > INITIAL : 252k
> > NEXT : 28k
> > PCTINCREASE : 0%
> >
> >
> > extent_id file_id block_id size in bytes
> > --------- ------- -------- -------------
> > 0 8 62 266240
> >
> > 1 8 127 40960
> >
> > 2 8 137 40960
> >
> >The question
> >------------
> >Is it normal that the extent allocated to the table ( 40960 != 28672 )
> >is not equal to the one specified in the create table statement.?
>
> Hanna,
>
> Which is the db_block_size of your database?
>
> Best Regards,
> --
> Luis Santos
> Banco InterAtlântico

Hi,
oracle will use increments of blocks divisible by 5. 28k for 2k block size would want 14 2k blocks. oracle will allocate 15 2k blocks. Your blocksize looks to be 4k. 28k divided by 4k = 7 blocks. Oracle will allocate 10 blocks hence segment size 40960 (4 x 1024 x 10).

Hope this clears it up for you.

Dick Received on Fri Aug 01 1997 - 00:00:00 CDT