-
SELECT OWNER, SEGMENT_NAME, SEGMENT_TYPE, BYTES, BYTES/1024/1024 AS "SIZE_MB" FROM DBA_SEGMENTS WHERE SEGMENT_TYPE = 'TABLE' ORDER BY BYTES DESC;