RE: Coalescing Freespace / pctincrease = 1

From: John Hallas <john.hallas_at_mail.com>
Date: Wed, 6 Dec 2000 14:05:36 -0000
Message-Id: <10702.123778@fatcity.com>

I do not believe there is a difference between setting pctincrease to any values other than zero.
i.e. any number >= 1 has the same effect (other than the size of the next extent).
To perform coalesce of tablespace set pctincrease to non-zero as you suggest.

-----Original Message-----

From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Steve.Parker_at_lis.co.uk
Sent: 06 December 2000 10:01
To: Multiple recipients of list ORACLE-L Subject: 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

E Mail: steve.parker_at_lis.co.uk

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: Steve.Parker_at_lis.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Dec 06 2000 - 08:05:36 CST