column owner format A7
column bytes format 99999999999
break ON owner ON report
compute SUM OF bytes ON owner report
SELECT owner, table_name, NVL(num_rows*avg_row_len,0) bytes
FROM dba_tables
WHERE tablespace_name='AR_DATA'
ORDER BY owner,table_name
/