Assuming your statistics are up to date, check dba_tables.num_rows and dba_segments.tablespace_name