alter tablespace coalesce will always works as long as you issue it manually. If you want Oracle to do it manually set pctincrease > 0 although personally I never set this value to bigger than zero.
Also when you talk defragmentation what kind are you referring? There are mainly three, Free Space, Extents, Block.




Reply With Quote