데이터베이스
오라클 DB공간 확인하기
거나미스
2006. 12. 26. 10:04
반응형
SELECT
a.tablespace_name, a.alloc, b.free, round((a.alloc-b.free)*100/a.alloc, 2)
FROM
(select
tablespace_name, sum(bytes)/1024 alloc
from
dba_data_files
group by
tablespace_name
) a,
(select
tablespace_name, sum(bytes)/1024 free
from
dba_free_space
group by
tablespace_name
) b
WHERE
a.tablespace_name = b.tablespace_name
ORDER BY
round((a.alloc-b.free)*100/a.alloc, 2)
간단히 확인할 수 있다. ^ㅁ^
a.tablespace_name, a.alloc, b.free, round((a.alloc-b.free)*100/a.alloc, 2)
FROM
(select
tablespace_name, sum(bytes)/1024 alloc
from
dba_data_files
group by
tablespace_name
) a,
(select
tablespace_name, sum(bytes)/1024 free
from
dba_free_space
group by
tablespace_name
) b
WHERE
a.tablespace_name = b.tablespace_name
ORDER BY
round((a.alloc-b.free)*100/a.alloc, 2)
간단히 확인할 수 있다. ^ㅁ^