Re: Defragment

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
>
Received on Mon Aug 17 1998 - 06:13:07 CDT