SELECT
 DT.TABLESPACE_NAME,
 DT.BLOCK_SIZE,
 DT.INITIAL_EXTENT,
 DT.NEXT_EXTENT,
 DT.MIN_EXTENTS,
 DT.MAX_EXTENTS,
 DT.PCT_INCREASE,
 DT.MIN_EXTLEN,
 DT.STATUS,
 DT.CONTENTS,
 DT.LOGGING,
 DT.FORCE_LOGGING,
 DT.EXTENT_MANAGEMENT,
 DT.ALLOCATION_TYPE,
 DT.PLUGGED_IN,
 DT.SEGMENT_SPACE_MANAGEMENT,
 DF.PERCENT_BLOCKS_COALESCED,
 DF.TOTAL_BYTES
FROM
 SYS.DBA_TABLESPACES DT,
 SYS.DBA_FREE_SPACE_COALESCED DF
WHERE
 DT.TABLESPACE_NAME = DF.TABLESPACE_NAME (+)
ORDER BY
 DT.TABLESPACE_NAME