Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Coalescing Freespace / pctincrease = 1
Regardless of the whether coalescing freespace is necessary/worthwhile,
can anyone confirm if the following is factually correct.
If pctincrease is set to more than 0, the next extent is calculated on the
size of the previous extent
using the pctincrease percentage value. But if it is set to 1 it is the
same as zero, just that it now
gives SMON the indication to coalesce free extents.
This came from a colleague, but I have searched the manuals and the web and
found no
evidence. Some people stated that they used pctincrease=1 to get SMON to
coalesce
and they could cope with the minimal extent size growth.
Thanks
Steve Parker
Technical Consultant
LIS
![]() |
![]() |