SELECT t.segment_name,TO_CHAR(SUM(BYTES)/(1024*1024),'999G999D999') CNT_MB FROM user_segments t WHERE SEGMENT_TYPE LIKE 'TABLE%' GROUP BY t.segment_name order by 2 desc;
