SELECT S.OWNER,

       S.SEGMENT_NAME,

       S.SEGMENT_TYPE,

       S.PARTITION_NAME,

       ROUND(BYTES / (1024 * 1024), 2) "USED_SPACE(M)",

       EXTENTS USED_EXTENTS,

       S.MAX_EXTENTS,

       S.BLOCKS ALLOCATED_BLOCKS,

       S.BLOCKS USED_BOLCKS,

       S.PCT_INCREASE,

       S.INITIAL_EXTENT,

       S.NEXT_EXTENT / 1024 "NEXT_EXTENT(K)",

       S.TABLESPACE_NAME

  FROM DBA_SEGMENTS S

WHERE S.OWNER = USER

ORDER BY Used_Extents DESC