It appears that avg_row_len goes hand in hand with num_rows, if there is no data to be averaged then you will get a 0.

MH


SQL>select owner, table_name,AVG_ROW_LEN, NUM_ROWS
from dba_tables
where owner='X-Mas_poo'
ORDER BY 3