Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Coalescing Freespace / pctincrease = 1
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
--
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 Liststo: 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
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
![]() |
![]() |