Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Fragmentation and TRUNCATE vs. DROP

Re: Fragmentation and TRUNCATE vs. DROP

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Thu, 18 Mar 2004 23:33:14 +1100
Message-ID: <4059970d$0$31907$afc38c87@news.optusnet.com.au>

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:40599632$0$6552$ed9e5944_at_reading.news.pipex.net...
> "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.

Cheers Niall. I guessed as much.
Regards
HJR Received on Thu Mar 18 2004 - 06:33:14 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US