- Tablespace 사용률 관리 확인 스크립트

- 스크립트

set lines 1000; col file# for 999; col ts_name for a10; col total_blocks for 9999999; col used_blocks for 9999999; col pct_used for a10; col file_dir for a45 select distinct d.file_id file#, d.tablespace_name ts_name, d.bytes /1024 / 1024 MB, d.bytes / 8192 MB, sum(e.blocks) used_blocks, to_char(nvl(round(sum(e.blocks)/(d.bytes/8192),4),0)*100,'09.99')|| ' %' pct_used, d.file_name file_dir from dba_extents e, dba_data_files d where d.file_id = e.file_id group by d.file_id , d.tablespace_name , d.bytes, d.file_name   order by 1,2;

 

- 조회결과