avg_row_len - does it include long raw

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

Quote:

---

Originally Posted by Nugpot

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

---

Try:

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

Quote:

---

Originally Posted by Nugpot

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.