Re: Coalesce Tablespace in 7.2?

In article <321C7497.1740_at_ionet.net> Dick Allie <dallie_at_ionet.net> writes:

> From: Dick Allie <dallie_at_ionet.net>
> Newsgroups: comp.databases.oracle
> Date: Thu, 22 Aug 1996 09:54:15 -0500
> Organization: Macklanburg-Duncan
 

> I'm not sure about 7.2 but in 7.1.6 if you set the default pctincrease
> to a value > zero eg. 1 for the tablespace it will coelesce the
> tablespace periodically when extents are given back to free space.

If you set pcticrease to 1, ORACLE will coalesce freespace (honeycombs), but this 1% increase will cause severe fragmentation because of the many different extent sizes you will get. Probably you will see more bubble fragmentation. Remember, you cannot delete bubble fragmentation without reorganizing your tablespace.

For further information, you should take a look at the white paper 'ORACLE Server Space Management' by Cary V. Millsap at

http://www.europa.com/~orapub

Axel Schlueter
schluete_at_informatik.uni-hannover.de Received on Fri Aug 23 1996 - 00:00:00 CEST