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 sql
delete, drop, truncate
statement comes into this "drop/truncate" situation?

other than that... if we issue a coalesce command, we wont be able to see any positive results?