Next Extent?

From: Hanna LTEIF <hanna.lteif_at_infotechnique.com>
Date: 1997/07/28
Message-ID: <33DCBB6F.569E@infotechnique.com>#1/1

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.?

Any help would be appreciated ?

Hanna
--
Received on Mon Jul 28 1997 - 00:00:00 CDT