Re: data file defragmentation
Date: 19 Jun 2003 23:30:43 -0700
Message-ID: <3bf82636.0306192230.60c6057e_at_posting.google.com>
"Ana C. Dent" <anacedent_at_hotmail.com> wrote in message news:<2_8Ga.81134$MJ5.71043_at_fed1read03>...
> cc wrote:
> > Hi all,
> >
> > I need to defragment a data file.
> > what is the best way for that?
> > Does Oracle (or other company) have any tool in order to defragment a data file?
>
> If the (OS) data file itself is fragmented
> (which it very well could be),
> then the fix MUST be done at the OS level
> and NOT within Oracle.
>
> Just curious,
> what actual evidence do you have of the fragmentation?
You could use 'coalesce' to get rid of unused extents. but this makes just sense if you have defined a pct_increase.
There is also the possibility to use the 'alter table ... move '
statement
which in turn also resets the high-water-mark. But during this reorg
the table is locked.
guenter Received on Fri Jun 20 2003 - 08:30:43 CEST