As far as my knowledge and my memory goes, the value of PCTINCREASE should be greater than 0 for SMON to coalesce the tablespace. [ 8.0.x]

Does this mean that I can have a PCTINCREASE of 0 for the indexes and tables in the tablespace and still expect SMON to coalesce the tablespace when appropriate?


Thanks in advance.

Hedy