select vsize(column1) + vsize(column2) + ...vsize(columnN)
from your_table
where ....

более полезный вариант:

analyze table your_table compute statistics;
select avg_row_len from user_tables where table_name = 'YOUR_TABLE';