Tablespace Coalesce

Jump Ahead

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;

Was this article helpful?

Related Articles

Leave a Comment