Oracle - tablespace 사용량
SELECT a.tablespace_name , a.total "Total(Mb)" , a.total - b.free "Used(Mb)" , nvl(b.free,0) "Free(Mb)" , round((a.total - nvl(b.free,0))*100/total,0) "Used(%)" from (select tablespace_name, round((sum(bytes)/1024/1024),0) as total from dba_data_files group by tablespace_name) a ,(select tablespace_name, round((sum(bytes)/1024/1024),0) as free from dba_free_space group by tablespace_name) b wher..
TABLESPACE 사용량 CHECK
select substr(t_tablespace_name ,1,22) as TABLESPACE_NAME, round(t_total_size/1024/1024) as TOTAL_SIZE, lpad(round((t_total_size-f_free_size)/1024/1024),6,' ')||'('||lpad(round((1-f_free_size/t_total_size)*100,.999),3,' ')||'%)' as USED, lpad(round(f_free_size/1024/1024),6,' ')||'('||lpad(round(f_free_size/t_total_size*100,.999),3,' ')||'%)' as FREE, trunc(f_max_size/1024/1024) as MAX_FREE, trun..