Hi,

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.


colA char(3)
colB varchar2(3)
colC number(5,2)
colD date
colE raw(25)
colF rowid
colG long
colH blob
colI clob


How much byte size Oracle considers against each column to calculate RowSize?

This would help lot of users in sizing objects.

TIA