For oracle run SHRINKS on NMS_MESSAGES daily
- often those tables get heavily fragmented due to bulk imports. when that happens, they grow in size consuming many blocks. That data is eventually deleted and normal usage does not need that many blocks.
- often those tables get heavily fragmented due to bulk imports. when that happens, they grow in size consuming many blocks. That data is eventually deleted and normal usage does not need that many blocks.
- ALTER TABLE NMS_MESSAGES ENABLE ROW MOVEMENT
- ALTER TABLE NMS_MESSAGES SHRINK SPACE CASCADE
- ALTER TABLE NMS_MESSAGE_DELIVERY ENABLE ROW MOVEMENT
ALTER TABLE NMS_MESSAGE_DELIVERY SHRINK SPACE CASCADE
