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

SELECT
 sid,
 SQL_TEXT,
 piece
FROM
 v$session se,
 sys.v_$sqltext sq
WHERE
 se.sql_address = sq.ADDRESS (+) AND
 se.SQL_HASH_VALUE = sq.HASH_VALUE (+) AND
 sid = 204
ORDER BY
 address,
 hash_value,
 piece