SYSTEM表領域の使用率(表領域)を確認する

set lines 120
set pages 100
set term off
col tablespace_name format a15
col "SIZE(KB)" format a20
col "USED(KB)" format a20
col "FREE(KB)" format a20
col "USED(%)" format 990.99

select
  tablespace_name
  ,to_char(nvl(ddf.total_bytes / 1024, 0),'999,999,999') as "size(KB)"
  ,to_char(nvl((ddf.total_bytes - dfs.free_total_bytes) / 1024,0),'999,999,999') as "used(KB)"
  ,to_char(nvl(dfs.free_total_bytes / 1024, 0),'999,999,999') as "free(KB)"
  ,round(nvl((ddf.total_bytes - dfs.free_total_bytes) / ddf.total_bytes * 100, 100), 2) as "rate(%)"
from
  (
  select
    tablespace_name
    ,sum(bytes) total_bytes
  from
    dba_data_files
  group by
    tablespace_name
  ) ddf,
  (
  select
    tablespace_name free_tablespace_name
    ,sum(bytes) free_total_bytes
  from
    dba_free_space
  group by
    tablespace_name
  ) dfs
where
  tablespace_name = free_tablespace_name(+)
  and tablespace_name = 'SYSTEM'
;