Break Out!? - blog ver.

前回は一時表領域だったけど
表領域の方は以下の SQL で調べられる

左から表領域のサイズ、利用サイズ、空きサイズ、使用率

SELECT tablespace_name,
TO_CHAR(nvl(total_bytes/1024/1024,0),'999,999,999') as "size(MB)",
TO_CHAR(nvl((total_bytes - free_total_bytes)/1024/1024,0),'999,999,999') as "used(MB)",
TO_CHAR(nvl(free_total_bytes/1024/1024,0),'999,999,999') as "free(MB)",
round(nvl((total_bytes-free_total_bytes)/total_bytes*100,100),2) as "rate(%)"
FROM (SELECT tablespace_name,
sum(bytes) total_bytes
FROM dba_data_files
GROUP BY tablespace_name),
(SELECT tablespace_name free_tablespace_name,
sum(bytes) free_total_bytes
FROM dba_free_space
GROUP BY tablespace_name)
WHERE tablespace_name = free_tablespace_name(+);