I am trying to avoid data block Migration as much as possible and understand how place data into datablocks. We have LONG ROW data type with size from 13K to 40K, the average size is 21K. Data block size is 16K.
My question is:
Suppose data block is 36K
for example extent has 3 blocks:
1: 21K used space - 15K free
2: 15K used space - 21K free
3: 30K used space - 6K free
Free list has blocks 1,2
I am trying to insert new row size 20K. Which data block Oracle will place new row in first or second? If it try to insert in first block so I will get row migration. If Oracle takes second block from Free list, I will not get migration. So How Oracle choose block from Free list according to size of row inserted or no?
try to look into ixora site (www.ixora.com.au)...
Click Here to Expand Forum to Full Width