Oracle 表領域の空きとサイズ確認をするSQL
SELECT tablespace_name "TableName", SUM(bytes)/1024/1024 --"空き領域(MB)"
FROM dba_free_space GROUP BY tablespace_name;
SELECT tablespace_name "TableName", SUM(bytes)/1024/1024 --"サイズ(MB)"
FROM dba_data_files GROUP BY tablespace_name;