Re: Coalesce problem

Your right. My bad.

In article <8t2358$fq6$1_at_nnrp1.deja.com>,   oratune_at_aol.com wrote:
> In article <8t1ur7$boc$1_at_nnrp1.deja.com>,
> jdarrah_co_at_my-deja.com wrote:
> > Alter tablespace coalesce will essentially merge adjacent extents of
> > the same table together. If you have percent increase set higher
 than
> > zero than smon will automatically coalesce the tablespace every 12
> > hours (don't quote me on the 12 hours part). The best way to combat
> > tablespace fragmentation is to use one and only one extent size per
> > tablespace and set percent increase to zero in your storage clauses.
> > If your using 8i, use locally managed tablespaces with a uniform
 extent
> > size. If not make sure only one size of extent goes into each TS or
 at
> > the very least, make sure all extents of a tablespace are multiples
 or
> > one another.
> >
> > In article <Pine.GSO.4.21.0010231825002.24382-
 100000_at_loisto.uwasa.fi>,
> > kt <h78816_at_loisto.uwasa.fi> wrote:
> > > Hi all!
> > >
> > > I'm quit new with the Oracle databases and would like to know what
> > > is the best way to find out that fragmentation of space is
> > > high (contiguous space on your disk appears as non-contiguous)?
> > >
> > > If I execute ALTER TABLESPACE <dbspace> COALESCE, what's happening
 to
> > > extents?
> > >
> > > Do I get more larger contiguous extents on a per tablespace basis
 by
> > > using that command?
> > >
> > > Or is there another ways to reorganisize tablespaces, except exp-
 imp?
> > >
> > > Thank's in forward.
> > >
> > > KT
> > >
> > >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
>
> This is incorrect. Please see the explanation I have already
> posted. 'ALTER TABLESPACE ... COALESCE' ONLY coalesces contiguous
> blocks of FREE SPACE. Table/index extents ARE NOT relocated to make
> them contiguous.
>
> --
> David Fitzjarrell
> Oracle Certified DBA
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Oct 25 2000 - 01:21:55 CEST