SELECT  
  fi.TABLESPACE_NAME      Tablespace,
  max(tbs.block_size)     block_size,
  sum(fi.BYTES)           tot,
  NVL(free,0) fsp,
  ( sum(fi.BYTES) - NVL(free,0) ) *100 / sum(fi.BYTES) pctused,
  no_of_exts  csp,
  e_max msp,
  max(tbs.initial_extent) ie,
  max(tbs.next_extent) ne,
  max(tbs.extent_management) em,
  max(tbs.segment_space_management) sm
FROM  sys.dba_data_files fi,dba_tablespaces tbs, 
     (SELECT TABLESPACE_NAME,
             sum(BYTES) free,
             max(BYTES) e_max,
             count(BYTES) no_of_exts
        FROM sys.dba_free_space 
       GROUP BY TABLESPACE_NAME) ex
WHERE fi.tablespace_name = ex.tablespace_name(+)  AND fi.tablespace_name = tbs.tablespace_name 
GROUP BY fi.tablespace_name,
       free,
       no_of_exts,
       e_max
ORDER BY pctused DESC;