Re: Coalescing of Free Space

Paul Osborn wrote:
> A friend of mine running Oracle 7.? on a Sequent box told me that
> their site had a problem with Oracle coalescing free space.
> Specifically, they found that Oracle did not coalesce free extents if
> the associated tablespace had its PCTINCREASE parameter set to 0.
> Once the parameter was set to 1%, Oracle began to coalesce the free
> space.

  System monitor coalesce the free space. The free space will be coalesced when there is no enough contigous free space to allocate for the extents to the segment. As a result, you can check this condition.

-- 
Name        : Lun Wing San
Title       : Oracle developer of the Hong Kong Productivity Council
              System Administrator and Oracle DBA of the Quick Response
Center
Email Addr. : sunny_at_hkpc.org
Telephone   : 852-2788-5841