Re: Coalescing of Free Space

Paul Osborn wrote:
>
> Hi:
>
> A friend of mine running Oracle 7.? on a Sequent box told me that
> their site had a problem with Oracle coalescing free space.
> Specifically, they found that Oracle did not coalesce free extents if
> the associated tablespace had its PCTINCREASE parameter set to 0.
> Once the parameter was set to 1%, Oracle began to coalesce the free
> space.
>
> My question is: has anyone else had this experience?
>
> Regards,
> Paul
>
> +--------------------------------------------------------------+
> | Paul Osborn Menlo Software |
> | posborn_at_menlosoftware.com http://www.menlosoftware.com/ |
> | V: 415.324.1286 744 College Avenue |
> | F: 415.324.1287 Menlo Park, CA 94025 USA |

 +--------------------------------------------------------------+

This is certainly the case in ORACLE 7.1.6 under unix. PCTINCREASE = 0 means no coalesance
PCTINCREASE > 0 means that PMON will attempt to coalesce free extents (that are next to each other physically) every 5 minutes. This is documented on ORACLE UK's OCIS system.

-- 
+---------------------------------------------------------------+
| Peter Wales                                                   |
| IT Operational Services                                       |
| HP Bulmer Ltd            "The Worlds Largest Cider Maker"     |
| MailTo:PAW_at_bulmer.com          http://www.bulmer.com          |
+---------------------------------------------------------------+