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: Next Extent?

Re: Next Extent?

From: Luis Santos <lsantos_at_pobox.com>
Date: 1997/08/01
Message-ID: <33de5c21.2349860@news.centroin.com.br>#1/1

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
Received on Fri Aug 01 1997 - 00:00:00 CDT

Original text of this message

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