Re: Coalescing of Free Space

posborn_at_menlosoftware.com (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
>

Hi there,

This happens in Version 7.3.x. In Oracle 7,2, you need to run a script which will coalesces all tablespaces. I am not sure whether it is a feature or bug in Oracle 7.3.x

Regards

N.Prabhakar Received on Tue Dec 03 1996 - 00:00:00 CET