Tablespace 단편화 현상
현상 분석
SELECT TABLESPACE_NAME, TOTAL_EXTENTS, PERCENT_EXTENTS_COALESCED
FROM DBA_FREE_COALESCED
WHERE PERCENT_EXTENTS_COALESCED <> 100;
조각모음
ALTER TABLESPACE EXAMPLE COALESCE;
SELECT TABLESPACE_NAME, TOTAL_EXTENTS, PERCENT_EXTENTS_COALESCED
FROM DBA_FREE_COALESCED
WHERE PERCENT_EXTENTS_COALESCED <> 100;
100이 될때까지 연속적으로 실행