All datafiles of tablespaces that are more than 85% full

low_free_space_tbs.sql

select df.tablespace_name "Tablespace",
  df.file_name "File",
  df.status "Status",
  df.autoextensible "Auto Extend?",
  round((df.bytes / 1073741824), 2) "Used GB",
  round((df.maxbytes / 1073741824), 2) "Max GB",
  round(100 * (df.bytes / df.maxbytes), 2) "% Used",
  round((df.increment_by * (df.bytes / df.blocks)) / 1073741824, 2) "Extent Size GB",
  round((df.maxbytes - df.bytes) / (df.increment_by * (df.bytes / df.blocks))) "Remaining Extensions",
  round(pu."pct_used", 2) "% Tablespace Used"
from
  (select tablespace_name,
    100 * (sum(bytes) / sum(maxbytes)) "pct_used"
  from dba_data_files
  group by tablespace_name) pu,
  (select tablespace_name,
    file_name,
    status,
    autoextensible,
    bytes,
    maxbytes,
    increment_by,
    blocks
  from dba_data_files) df
where (pu.tablespace_name = df.tablespace_name)
and (pu."pct_used" > 85)
order by 10 DESC;