Tablo Büyüklükleri - Basit

select owner, table_name, round((num_rows*avg_row_len)/(1024*1024)) MB
from all_tables
where owner='BURHAND' -- Exclude system tables.
and num_rows > 0  -- Ignore empty Tables.
order by MB desc -- Biggest first.;