"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message
news:40598db9$0$3956$afc38c87_at_news.optusnet.com.au...
> Any indication in the text as to when this particular gem was written?
> Because it's pretty ancient advice these days. The whole idea of
controlling
> fragmentation by creating fewer extents went out the window with the
> introduction of uniform sized locally managed tablespace. With US-LMTs,
> every extent is the same size for all segments within a given tablespace,
> and therefore fragmentation can never, ever happen. Doesn't matter how
many
> extents you've got.
> The advice would therefore appear to be coming from the dark ages of
version
> 8.0 or before.
Originally written in 1999, last updated in 2001 but doesn't so far as I can
see cover LMT.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
Received on Thu Mar 18 2004 - 06:29:38 CST
