테이블스페이스

1. 테이블 스페이스 늘리기

alter tablespace POPS_IDX add datafile '/data/idx/psix02.dbf' size 4096M ;

2. 사용량 보기

set pau off
set trimspool on
column totalsize heading "total size(M)"
column usedsize heading "used size(M)"
column freesize heading "free size(M)"
column tablespace_name format a20
column totalsize format 999,999.9
column usedsize format 999,999.9
column freesize format 999,999.9
column used_percent format 999.9

select a.tablespace_name, a.totalsize,
nvl(b.usedsize,0) usedsize,nvl(round(((b.usedsize/a.totalsize)*100),1),0) Used_Perce
nt,c.freesize
from ( select tablespace_name, sum(bytes)/1024/1024 totalsize
from dba_data_files
group by tablespace_name ) a,
( select tablespace_name, sum(bytes)/1024/1024 usedsize
from dba_segments
group by tablespace_name ) b,
( select tablespace_name, sum(bytes)/1024/1024 freesize
from dba_free_space
group by tablespace_name ) c
where a.tablespace_name = b.tablespace_name(+)
and a.tablespace_name = c.tablespace_name(+)
order by 4
/