RE: different avg_row_len in 9i and 10g+ at table with LOB

I don't know if it is relevant here, but be aware that dbms_lob.getlength will return the number of characters in a clob, not the number of bytes. Also the characterset used to store text in a clob is depending on your db characterset, the db version and your platform. For instance: on a 10g AL32UTF8 database on linux, the text in a clob is stored using the AL16UTF16 characterset, which is a fixed 2 byte width. This would mean you need to multiply the result of dbms_getlength by 2, to get the actual number of bytes.

See metalink note: 257772.1 - CLOBs and NCLOBs character set storage in Oracle Release 8i, 9i and 10g for an overview.

regards,

Freek D'Hooge
Uptime
Oracle Database Administrator
e-mail: freek.dhooge_at_uptime.be
tel. +32 (0)3 451 23 82
http://www.uptime.be

--
http://www.freelists.org/webpage/oracle-l