Re: fragmentation issues

From: Dave <david.sharples3_at_ntlXworld.com>
Date: Sat, 29 May 2004 08:57:13 +0100
Message-ID: <_fYtc.11$31.5@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? Received on Sat May 29 2004 - 02:57:13 CDT