9 08 2017
Oracle 용량 관련 DDL
Haeng Ho Kang | Uncategorized, DataBase, Oracle |
|
|
SELECT A.TABLESPACE_NAME, ROUND(SUM(A.BYTES) / (1024 * 1024)) || 'M' "전체", --3 ROUND(SUM(B.FREES) / (1024 * 1024)) || 'M' "여유" -- 4 FROM (SELECT FILE_ID, TABLESPACE_NAME, SUM(BYTES) BYTES FROM DBA_DATA_FILES -- 1 GROUP BY FILE_ID, TABLESPACE_NAME) A INNER JOIN (SELECT TABLESPACE_NAME, FILE_ID, SUM(BYTES) FREES FROM DBA_FREE_SPACE -- 2 GROUP BY TABLESPACE_NAME, FILE_ID) B ON A.TABLESPACE_NAME = B.TABLESPACE_NAME AND A.FILE_ID = B.FILE_ID GROUP BY A.TABLESPACE_NAME; |
|
|
select tablespace_name, bytes/1024/1024 MB, file_name from dba_data_files; |
|
|
alter tablespace TabseSpace add datafile '/경로/DataBaseFiles/테이블스페이스02.dbf' size 5138022400; |