Tamilselvan,

Shouldn't your findings be of concern to those who deal in 10**6 records ?
I think this directly affects segment growth rates which in turn determines the backup and recovery and segment management (like index rebuilds etc...) techniques implemented by the DBA.
So any space management techniques that can be exploited in the physical d/b design should be thoroughly researched, and your findings are a perfect example of that.

It would be interesting for someone with the tools and detemination (may be it already exists) to generate excel graphs that would display the relation ship of the # of rows,block size, pctfree, pctused, initran, etc.. (other segment size parameters) on segment growth.

Am I thinking correct here ? I am new to d/b management so this kind of information goes a long way.