Something very interesting (I hope for you too) - in 10G the avg_row_len does not depends on the position of the emply columns - I tested with table with 298 columns, then I created several copies of the table with the columns ordered by num_distinct asc/desc from user_tab_columns and after analyze the avg_row_len is the same on the original and on the copies with reordered columns.
What the ...