Originally posted by bhallar
I din't find any Oracle-published alogorthim for AUTOALLOCATE. Looks like to me first 16 extents are of 8K and then next 128K (9.2.0.3)
[/url]
It starts with 64K extents, not 8K. Your block size is obviously 8K and your query reported initial extents to be 8 blocks, not 8 Kb.

For a brief description how autoallocate algorythm (might) works, check this discussion (my reply on page 3):

http://www.dbasupport.com/forums/sho...0&pagenumber=3