Re: fragmentation issues

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Sat, 29 May 2004 18:06:45 +1000
Message-ID: <40b84485$0$31678$afc38c87@news.optusnet.com.au>

"Dave" <david.sharples3_at_ntlXworld.com> wrote in message news:_fYtc.11$31.5_at_newsfe2-gui.server.ntli.net...
>
> "yls177" <yls177_at_hotmail.com> wrote in message
> news:c06e4d68.0405281858.778abb5f_at_posting.google.com...
> > 1) using locally managed tablespaces with uniform extent sizes means
> > that it is physically impossible to have fragmentation.
> >
> > 2) using dictionary managed tablespaces but create all objects
> > with initial=next and pctincrease=0 and keep all same sized objects in
> > a
> > tablespace together, fragmentation is minimized
> >
> >
> > (1) is very clearcut... but my conerns are with (2) since right now, i
> > have huge databases around 1.5GB that are on DMT. My thoughts are that
>
> 1.5GB = Huge?

Mmmm. True. I read that as "TB". Maybe the guy just mis-typed a little?

Regards
HJR Received on Sat May 29 2004 - 03:06:45 CDT