Hi,

I have a table with only one column which is of type CLOB.

When I insert more than 4000 bytes, avg_row_len column shows me 44, if I insert around 8000 bytes the it shows me 48 ...

If rowsize is below 3964 bytes, then avg_row_len columns shows me whatever is the size of row.. But once it gets more than 3964 byes... the 44 and 48 business starts.. if bytes in row are 4000 or 8000 resp..

Please explain how these 44 and 48 are calculated?

I have just inserted only one record in this table.. I just wanted to know how row size calculation take place for CLOB datatype column

Thanks

Sameer