Re: Coalescing of Free Space
From: Chuck Hamilton <chuckh_at_dvol.com>
Date: 1996/12/04
Message-ID: <32ab952c.7886845_at_n5.gbso.net>#1/1
>>
>> Hi:
>>
>> 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?
>>
>> Regards,
>> Paul
Date: 1996/12/04
Message-ID: <32ab952c.7886845_at_n5.gbso.net>#1/1
Michael Abbey <msabbey_at_magi.com> wrote:
>Paul Osborn wrote:
>>
>> Hi:
>>
>> 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?
>>
>> Regards,
>> Paul
I've experienced this too. My solution was to set the default pctincrease for the tablespace to 1, and always specify 0 when creating objects in it.
-- Chuck Hamilton chuckh_at_dvol.com This message delivered by electronic sled dogs. WOOF!Received on Wed Dec 04 1996 - 00:00:00 CET