Re: Fragmentation of a tablespace

For further discussion of this topic see

'Avoiding a tablespace fragmentation' an artice the Craig A Schallahamer to be found on the www.orapub.com site. Or it was last time I looked, under the Free Papers banner

Two key issues discussed here are

    1 - the different types of fragmentation     2 - actions for each - including the importance of PCTFREE and PCTUSED

Regards

--
Kevin A Lewis (BOCM PAULS LTD - Animal Feed Manufacturer - Ipswich England)

                        <KevinALewis_at_HotMail.com>

The views expressed herein by the author of this document are not necessarily those of BOCM PAULS Ltd. Thiru <tmgn_at_excite.com> wrote in message news:37EA946D.5432F6D4_at_excite.com...
> 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 Fri Sep 24 1999 - 03:54:23 CDT