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 |

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

Whether we all agree with it or not, this is the design of coalescing free space that started somewhere in 7.1. It is specifically designed to ensure that temporary tablespaces are not coalesced since their PCTINCREASE is usually set to 0.

Michael

###################################################################
# Michael Abbey           Ottawa ON Canada      613 780 2364
#
# Co-author of:   Tuning Oracle          Oracle: A Beginner's Guide
#                 Oracle Data Warehousing
###################################################################