Hi,
It is Oracle 9i the tablespace is LMT, extent management local uniform size 1MB, segment space management manual.
Question
======
1. Wheter we need to Coalesce the tablespaces..?
2. If answer to point(1) is "YES", how to know which tablespace is a candidate for Coalesce.
3. If answer to point(1) is "YES", is there any way we can estimate how long it will take for Coalesce for induvidual tablespace.
Thanks..