How to evaluate row size
I am having a table of 12 columns (in that order) :
Number(4),Number(1),Number(4),Number(5),Number(5),Number(3),Number(3),Number(3),Number(3),Char(1),Char(1),Number(1).
This table contains around 20 milion rows.
According to the Oracle 8i Concepts manual, I was expecting to have a row size of 3+2+3+4+4+3+3+3+3+1+1+2 = 32 bytes.
After computing statistics with the analyze command, I check that each row takes 44 bytes, but dividing the table size by the number of rows, I get a row size of 51 bytes. Does anybody have any explanation about these differences, and how to compute the real row size ?