Oracle Tablesspace 증가 시키기.

1. Oracle 테이블 스페이스 용량 확인

SELECT b.file_name "FILE_NAME", -- DataFile Name
b.tablespace_name "TABLESPACE_NAME", -- TableSpace Name
b.bytes / 1024 "TOTAL SIZE(KB)", -- ? Bytes
    ((b.bytes - sum(nvl(a.bytes,0)))) / 1024 "USED(KB)",
    (sum(nvl(a.bytes,0))) / 1024 "FREE SIZE(KB)",
    (sum(nvl(a.bytes,0)) / (b.bytes)) * 100 "FREE %"
    FROM DBA_FREE_SPACE a, DBA_DATA_FILES b
    WHERE a.file_id(+) = b.file_id
    GROUP BY b.tablespace_name, b.file_name, b.bytes
   ORDER BY b.tablespace_name;

SELECT file_name, tablespace_name, bytes, status FROM DBA_DATA_FILES

2. Oracle 테이블스페이스 증가 및 자동증가 설정

ALTER DATABASE DATAFILE '/home/oracledata/SmartDB/SMART_DATA01.dbf' RESIZE 2000M
                 AUTOEXTEND ON       
                 NEXT 100M                 
                 MAXSIZE 4000M ;