RE: Coalescing Freespace / pctincrease = 1

This is incorrect.. Setting pctincrease to 1 is not the same as 0. It will cause smon to coalesce, but your extent sizes will grow.

It never looks at the last extent to determine the size of the next. I'm not exactly sure how it determines it, but I assume it's from the extent info in the segment header.

As a test one day I created a segment 8k initial and 8k next. By about the 20th extent my next was up in the 200k range.

HTH
Shawn M Ferris
Oracle DBA - Time Warner Telecom

> -----Original Message-----
> From: Steve.Parker_at_lis.co.uk [mailto:Steve.Parker_at_lis.co.uk]
> Sent: Wednesday, December 06, 2000 3:01 AM
> 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 - 16:43:43 CST