DwayneHoover.com

This is another no brainer, just here for reference.

SQL> SELECT segment_name tbl, sum(bytes)/(1024*1024) size_MB
     from dba_extents where segment_type='TABLE'
     and segment_name LIKE 'your big tables'
     GROUP BY segment_name;