From: Margaret Pitts Subject: Re: Next Extent? Date: 1997/07/29 Message-ID: #1/1 References: <33DCBB6F.569E@infotechnique.com> Organization: Mincom Pty Ltd Newsgroups: comp.databases.oracle.server > 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@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