Re: Why tablespaces still need coalescing

By 'THAT' do you mean the MINIMUM EXTENT clause or the general principles envolved with extent sizing. I would asume you mean the former. The clause is available from 8.0 on the create tablespace command. The principles apply for any version as far as I am aware.

Regards

--
Kevin A Lewis (BOCM PAULS LTD) - Animal Feed Manufacturer - Ipswich United
Kingdom)
                        <Kevin_A_Lewis_at_Hotmail.com>

The views expressed herein by the author of this document
are not necessarily those of BOCM PAULS Ltd.
Gary <neilc-olops_at_btinternet.com> wrote in message
news:38C61900.2C673F3D_at_btinternet.com...


> Is that available on 7.3 ?

>

> Jonathan Lewis wrote:

> >

> > The tablespace does not need coalescing.

> > This is NOT because some magic makes

> > it happen invisibly and automatically, its

> > just because it isn't necessary.

> >

> > If all extents are the same size, all the

> > holes left by dropping an object are the

> > same size (although adjacent ones will

> > coalesce as the drop take places, so

> > some holes will be multiples of the

> > 'unit hole-size'.

> >

> > Since all the holes are 'the correct size'

> > the next time you create an object, it

> > will pick some of the available holes

> > straight away without having to thrash

> > around looking for a large enough chunk

> > and without leaving odd little bubbles of

> > space all over the place.

> >

> > N.B.  Have you also set MINIMUM EXTENT

> > for the tablespace as well is initial, next

> > and pctincrease ?

> >

> > --

> >

> > Jonathan Lewis

> > Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

> >

> > Wilko wrote in message <8a4c7n$or49_at_inetbws1.citec.com.au>...

> > >

> > >I am using oracle 7.3 and all the extents are the same size

> > >each tablespace. However, the tablespaces still need coalescing.

> > >

> > >Any ideas?

> > >