Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Fragmentation and TRUNCATE vs. DROP
"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 UKReceived on Thu Mar 18 2004 - 06:29:38 CST
![]() |
![]() |