There are lot of threads in Metalink about how much bytes Oracle really calculate while calcultaing actual Row Length.
Does someone have exact and realistic information about how many extra length bytes oracle considers for the following data types.
CHAR, VARCHAR2, DATE, NUMBER, RAW, ROWID, LONG, BLOB, CLOB.
Below given is an example table.
Table A has foll. columns.
How much byte size Oracle considers against each column to calculate RowSize?
This would help lot of users in sizing objects.
To handle yourself, use your head. To handle others, use your heart
Click Here to Expand Forum to Full Width