Re: Coalescing of Free Space
From: Kevin Loney <"75663,327"_at_compuserve.com>
Date: 1996/12/03
Message-ID: <32A4D350.27B5_at_compuserve.com>#1/1
Date: 1996/12/03
Message-ID: <32A4D350.27B5_at_compuserve.com>#1/1
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.
>
> My question is: has anyone else had this experience?
>
Everyone running 7.1 or over has had this experience. Set the tablespace's default pctincrease to 1, and the tables' pctincrease to 0 (so the tables grow linearly, while space is coalesced). Received on Tue Dec 03 1996 - 00:00:00 CET