Oracle Tablespace Doluluk Oranı (Autoextend Dahil)

SELECT df.tablespace_name,
       ROUND(df.max_mb, 0)  AS max_mb,
       ROUND(df.alloc_mb, 0) AS allocated_mb,
       ROUND(df.alloc_mb - NVL(fs.free_mb, 0), 0) AS used_mb,
       ROUND(100 * (df.alloc_mb - NVL(fs.free_mb, 0)) / df.max_mb, 1) AS used_pct_of_max
FROM (SELECT tablespace_name,
             SUM(bytes) / 1048576 AS alloc_mb,
             SUM(CASE WHEN autoextensible = 'YES' THEN GREATEST(maxbytes, bytes) ELSE bytes END) / 1048576 AS max_mb
      FROM dba_data_files GROUP BY tablespace_name) df
LEFT JOIN (SELECT tablespace_name, SUM(bytes) / 1048576 AS free_mb
           FROM dba_free_space GROUP BY tablespace_name) fs
       ON fs.tablespace_name = df.tablespace_name
ORDER BY used_pct_of_max DESC;