Re: Coalescing Empty SPace in a Data Block

The coalescing feature of ORACLE allows smon to coalesce contiguous empty extents which are essentially groups of data blocks. (or "chunks") and thereby create larger chunks of free space in that tablespace. Coalescing within a data block at a finer level of granularity than ORACLE supports.

Smon will automatically coalesce if the PCTINCREASE on the tablespace is greater than 0. Otherwise, one should use: alter tablespace <tablespace_name> coalesce; Received on Sun Sep 07 1997 - 00:00:00 CDT