Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Coalescing Freespace / pctincrease = 1

Coalescing Freespace / pctincrease = 1

From: <Steve.Parker_at_lis.co.uk>
Date: Wed, 6 Dec 2000 09:57:20 +0000
Message-Id: <10702.123760@fatcity.com>


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



E Mail: steve.parker_at_lis.co.uk
Received on Wed Dec 06 2000 - 03:57:20 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US