SQL 查詢 tablespace

SELECT df.tablespace_name TABLESPACE,
       df.max_space_gb max_space_gb,
       df.total_space_gb total_space_gb,
       (df.total_space_gb - fs.free_space_gb) used_space_gb,
       fs.free_space_gb free_space_gb, ROUND(100 * (fs.free_space_gb / df.total_space_gb), 2) pct_free,
       ROUND(100 - 100 * (df.total_space_gb - fs.free_space_gb) / df.max_space_gb, 2) pct_max_free
  FROM (SELECT tablespace_name,
               ROUND(SUM(DECODE(autoextensible, 'YES', maxbytes, bytes)) / 1073741824, 2) max_space_gb,
               ROUND(SUM(bytes) / 1073741824, 2) total_space_gb
          FROM dba_data_files
         GROUP BY tablespace_name) df,
       (SELECT tablespace_name,
               ROUND(SUM(bytes) / 1073741824, 3) free_space_gb
          FROM dba_free_space
         GROUP BY tablespace_name) fs
 WHERE df.tablespace_name = fs.tablespace_name(+)
 ORDER BY fs.tablespace_name;

SELECT df.tablespace_name tablespace, df.max_space_gb max_space_gb, df.total_space_gb total_space_gb, (df.total_space_gb - fs.free_space_gb) used_space_gb, fs.free_space_gb free_space_gb, round(100 * (fs.free_space_gb / df.total_space_gb), 2) pct_free, round(100 - 100 * (df.total_space_gb - fs.free_space_gb) / df.max_space_gb, 2) pct_max_free FROM (SELECT tablespace_name, round(SUM(decode(autoextensible, 'YES', maxbytes, bytes)) / 1073741824, 2) max_space_gb, round(SUM(bytes) / 1073741824, 2) total_space_gb FROM dba_data_files GROUP BY tablespace_name) df, (SELECT tablespace_name, round(SUM(bytes) / 1073741824, 3) free_space_gb FROM dba_free_space GROUP BY tablespace_name) fs WHERE df.tablespace_name = fs.tablespace_name(+) ORDER BY fs.tablespace_name;