when you insert data into extents, DBWR looks for an extent which is bigger than the current extent (if PCTINCREASE > 0). If SMON doesn't coalesce the free space into larger extents, data never gets inserted into those extents and the tablespace gets fragmented.




Reply With Quote