If you never drop / truncate -- you never need to coalesce.
If you frequently drop / truncate -- these objects belong in their own "special"
tablespace, one that you can coalesce whenever you feel like.
And so, only the sqlstatement comes into this "drop/truncate" situation?delete, drop, truncate
other than that... if we issue a coalesce command, we wont be able to see any positive results?