avg_row_len - does it include long raw

[Nugpot]

Hi,

Does the value in avg_row_len(dba_tables) include the long raw column ...
If not, how do i find the avg-row-len for a table with long raw's..

Thanks
Vj

[Telco_DBA]

Does the value in avg_row_len(dba_tables) include the long raw column ...

Try:

SQL> select column_name, vsize(columname) from tablename .....;

If not, how do i find the avg-row-len for a table with long raw's..

Divide the size of the table by the number of rows.