Re: Defragment

Hi Patrick,

   A useful trick I picked up is to make all of the extents in a tablespace the same size. In the case of small tables it does waste some space, but it eliminates fragmentation.

regards

Jerry

Patrick wrote:
>
> To coalesce free space (normally perfomed by SMON excepted when
> pctincrease=0)
>
> alter tablespace XXX coalesce;
>
> You can also put an event in init.ora (ask Oracle for that) to coalesce
> even if pctincrease=0
>
> If you have many datafiles for one tablespace you cannot avoid some
> fragmentation. i would suggest regrouping in one
> datafile, depending on max supported size (depends on OS & version)
>
> Don't forget fragmentation at OS filesystem level. There are generally some
> tools available to defragment filesystem.
>
> Patrick Wtterwulghe
> Oracle DBA
>
> laurencen_at_my-dejanews.com wrote in article
> <6qvd5k$k1g$1_at_nnrp1.dejanews.com>...
> > Hi
> >
> > I am new at the role of the DBA and I have no prior experiences with
> Oracle.
> > We have Oracle Financal applications and I was wondering what I need to
> do
> > when I am ready to defragment a tablespace. An example: GLDX tablespace
> needs
> > defragmented. What are the necessary steps I could take?
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> > http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
> >

--

Jerry Gitomer         	ICT Group
jgitomer_at_ictgroup.com	Langhorne PA
jgitomer_at_yahoo.com 	Opinions are mine not those of ICT Group