DBA Weekly Task
- For each datafile in the tablespace, it combines all contiguous free extents into larger contiguous extents.
- It is a command to take any free extents that are right next to some other free extent and make one bigger free extent.
- SMON will perform this coalescing in the background but if you need it to happen right now, coalesce will do it.
ALTER TABLESPACE USERS COALESCE;