Re: extents

"Tom Best" <tabest_at_bellatlantic.dontspamme.net> wrote in message news:vYxh5.3813$oA6.201271_at_typhoon2.ba-dsg.net...
> Nuno:
>
> If PCTINCREASE is 0, then do you make it a habit to manually defragment on
> occasion (since Oracle only defrags if PCTINCREASE > 0)?
>

No such thing as defragmenting, but if you mean coalescing, then the point of having PCTINCREASE=0 (and ensuring consistent extent sizes within the tablespace) is that you don't ever *need* to coalesce. If all your extent sizes are the same, no segment will ever not be able to re-use a free one.

Regards
HJR
> Thanks,
> Tom Best
>
> Nuno Souto <nsouto_at_nsw.bigpond.net.au.nospam> wrote in message
> news:3986a84e.1963144_at_news-server...
> > On Mon, 31 Jul 2000 06:57:02 -0700, Mark D Powell
> > <mark.powellNOmaSPAM_at_eds.com.invalid> wrote:
> >
> > >depend mostly on your tablespace space management policies. I
> > >believe that Oracle currently recommends to assign the same
> > >extent size to all objects in the tablespace, initial=next and
> > >pctincrease=0. This makes every free extent available for use
> > >by any object that needs to extend. I think it is more
> > >important to organize large objects this way than it is for
> > >small objects.
> >
> > Hehehe! They _finally_ recomending that? Been using it since V6, 12
> > yaears ago...
> >
> > On another note: going this way, it's handy to separate your database
> > into volatile tables and static tables. Then for each group, there
> > should be a "small" tablespace, a "middle" tablespace and a "large"
> > tablespace. Not necessarily in overall size but more to do with the
> > default storage parameters of the each tablespace. And of course, try
> > to have all extents within the same tablespace the same size. That
> > makes free space and used space management and defragmenting easy as
> > pie.
> >
> > This is a minimum. Of course, there are more refinements to make, but
> > that's highly case-by-case.
> >
> > HTH
> >
> > Cheers
> > Nuno Souto
> > nsouto_at_nsw.bigpond.net.au.nospam
> > http://www.users.bigpond.net.au/the_Den/index.html
>
>
Received on Tue Aug 01 2000 - 00:00:00 CDT