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: <hongs_at_lge.co.kr>
Date: 1997/07/29
Message-ID: <870164104.13034@dejanews.com>#1/1

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.



Sungsook Hong
Oracle DBA
LG Electronics Inc.
-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet
Received on Tue Jul 29 1997 - 00:00:00 CDT

Original text of this message

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