Re: tablespace fragmentation

From: Luis de Diego <ldiego_at_anaya.es>
Date: 1997/11/17
Message-ID: <34702EE4.81BE53C1@anaya.es>#1/1

This is a multi-part message in MIME format.

--------------13F889DD40B8B49D1C3375E3
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hello.

I think that in versions before 7.2 you can make the background processes to coalesce the space by setting the PCTINCREASE of the tablespace storage parameters to a non 0 value.

Hope this helps.

Amit Aggarwal wrote:

> Hi Guys:
>
> I have a question about tablespace fragmentation.
>
> We have an Oracle 7.1.3 database running on Digital Unix. Recently I
> noticed that most of the tablepsaces are badly fragmented and after
> looking in the 'DBA_FREE_SPACE' table, I found out that there are lot of
> contiguous free extents. I tried the command:
> ALTER TABLESPACE <name> COALESCE;
>
> to defragment the tablespaces but it seems like that that command was
> not there in 7.1.3. Is there any other way to fix this fragmentation in
> the tablespaces in 7.1.3. I know this command works fine in 7.3.
>
> Thanks for replying
>
> amit
> Oracle DBA/Unix SA

--------------13F889DD40B8B49D1C3375E3
Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Luis de Diego
Content-Disposition: attachment; filename="vcard.vcf"

begin:          vcard
fn:             Luis de Diego
n:              de Diego;Luis
org:            Sistemas y Desarrollos Informáticos
adr:            Juan Ignacio Luca de Tena 15;;;MADRID;MADRID;28027;ESPAÑA
email;internet: ldiego_at_anaya.es
title:          Desarrollador Aventura Educativa - Administrador de BBDD
tel;work:       07 34 1 393 86 62

x-mozilla-cpt: ;0
x-mozilla-html: TRUE

version:        2.1
end:            vcard

--------------13F889DD40B8B49D1C3375E3-- Received on Mon Nov 17 1997 - 00:00:00 CST