Re: Next Extent?

> HI,
>
> I have this situation, i created a table with theses parameters:
>
> INITIAL : 252k
> NEXT : 28k
> PCTINCREASE : 0%
>
> We do a lot of insert and delete on that table. SO the problem(?), is
> that i was selecting the information from the table sys.dba_extents for
> that specific table, to see how many extents it did consume until now,
> and the result of the select is :
>
> 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.?
>

I believe that the minimum allocation space for any object is 5 Oracle blocks. If you have your db_block_size set to 8K, this would explain why extent size is 40K.

Marg.

--
 mailto:mpitts_at_mincom.com       |  | |  |  |  |     Mincom Pty Ltd
 Systems Consultant - Unix      |M |I|N |C |O |M   ACN 010 087 608
 MIMS Customer Services - Technical                   Brisbane QLD
 http://www.mincom.com    Ph/Fx: +61-7-3364 99 99/70     Australia