Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Next Extent?
In article
<Pine.HPP.3.91.970729133923.16442D-100000-100000-100000_at_saturn.mincom.oz.au>,
Margaret Pitts <mpitts_at_saturn.mincom.oz.au> wrote:
>
> > 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.
Right. For more detailed information, refer to the SERVER ADMINISTRATOR'S
GUIDE.
> If you have your db_block_size set to 8K, this would explain why extent size
is
> 40K.
In this case, the value of db_block_size is 4k, not 8k. extent_id 0 starts at 62 and ends at 126, occupying 65 contiguos blocks.So the extent size is 4096bytes*65=266240bytes. extent_id 1 and 2 take 10 blocks each.
-------------------==== Posted via Deja News ====----------------------- http://www.dejanews.com/ Search, Read, Post to UsenetReceived on Tue Jul 29 1997 - 00:00:00 CDT