Re: Fragmentation of a tablespace

Since your system is 24*7, it is really difficult to achieve high levels of Defragmentaion ,that is possible with Exp/REsize/Imp ..

However you can prevent further Fragmentation by REbuilding the Indexes Online,Setup a Cron job which can periodically Coalesce the Free Space in the Tablespaces ( Forcing a Non-zero PctIncrease(to Enable Smon's automatic coalesce) will lead only to non linear extents and further fragmentation) , Size the NEXT extent of the Fragmented Tables to avoid further fragmentation.

Also you can size the MINEXTENT_LENGTH to avoid Free space fragmentation..

I'm still not sure if Platinum's TS Reorg supports Online Defragmentation..

Hope this helps..

-Thiru

Java Development wrote:

> Hi out there,
>
> I'm working as a DBA on a medium database with about 20 GByte of
> datafiles. One tablespace
> with about 14 GByte has become fragmentated in the last year. So I have
> to defragmentate it in
> the near future. I don't like to export all tables and to import it
> again, because it is an online system,
> 24 hours a day and 7 days a week.
> Is there anybody out there (stolen from Pink Floyd) with a good idea
> that helps me ??
>
> Thanks a lot
> Carsten Mohr
Received on Thu Sep 23 1999 - 15:58:21 CDT