Oracle 테이블스페이스 확인

TABLESPACE 리스트

SELECT tablespace_name, initial_extent “INITIAL”, next_extent “NEXT”,
min_extents, max_extents, pct_increase, status
FROM dba_tablespaces;

사이즈와 사용량 확인

select
d.tablespace_name,
CURRENT_SIZE “TOTAL[MB]”,
round(CURRENT_SIZE – EMPTY_SIZE) “USED[MB]”,
round((1 – (EMPTY_SIZE/CURRENT_SIZE ))*100) “USED(%)”,
EMPTY_SIZE “EMPTY[MB]”
from
(SELECT tablespace_name, round(SUM(bytes)/(1024*1024)) “CURRENT_SIZE”
FROM dba_data_files GROUP BY tablespace_name) d,
(SELECT tablespace_name, round(SUM(bytes)/(1024*1024)) “EMPTY_SIZE”
FROM dba_free_space GROUP BY tablespace_name) f
where d.tablespace_name=f.tablespace_name;

This entry was posted in Oracle. Bookmark the permalink.