Originally posted by agasimani
Remember this point:
For autoallocate in locally managed tablespace Oracle manages all extent allocation and sizing automatically, based on whatever value is specified for the initial extent. So the next extent is always the same as initial extent.
This is not true if you are using AUTOALLOCATE. Oracle allocate extents of size based on grwoth of the table.
Excerpts from Oracle Magazine:
If you create a new table, the first extent will be 64KB in size. Subsequent extents will also be 64KB, until the table reaches 1MB in size. At that point the size of subsequent extents for the table will be increased to 1MB. When the table reaches 64MB in size, the extent size will be increased again to 8MB. Finally, if the table reaches a size of 1GB, the extent size will be increased one last time, to 64MB.
http://www.oracle.com/oramag/oracle/...ml?o60o8i.html
Turin,
Are you sure about the results posted from DBA_SEGMENTS ? I see the table only one extent big.
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"