database/oracle
SEGMENT SHRINK: REORG
아이짱구
2017. 2. 1. 13:47
ALTER TABLE TABLE_NAME ENABLE ROW MOVEMENT;
ALTER TABLE TABLE_NAME SHRINK SPACE CASCADE;
ALTER TABLE TABLE_NAME DISABLE ROW MOVEMENT;
1MB당 평균 약 2초의 REORG 시간 소요.