Hi Hari,

You are right about next extent. It works this way

Extent 1: 100KB
Extent 2: 100KB
Extent 3: 100KB+50%of100KB=150KB
Extent 4: 100KB+50%of150KB=175KB
and so on.

But there is another thing u need to make check is these value might get adjusted if defined extent in create statement is not evenly divided by block size.

what block size u are using ?


i would just run simple test by creating table and insert some rows so it will create extent and u can check out.

Thanks
Gc