Wasn't one of the major reasons for this so that we could consign DMTs to
history !
we could get on and worry more about Larry's yachting expertise.
"Charlie Edwards" <charlie3101_at_hotmail.com> wrote in message
news:217ac5a8.0301100657.43251985_at_posting.google.com...
> Oracle 8.1.7.2
>
> Well, on my last project I finally convinced my DBA to try LMTs. So
> he knows about them.
>
> I get transferred to another project and, lo-and-behold, we're back to
> Dictionary Managed Tablespaces (sigh), with tables and indexes in
> separate tablespaces (double sigh).
>
> He says theres no advantage to LMTs as long as you ensure that your
> PCTINCREASE is 0 and your extents are always <4 blocks * (a power of
> 2)> - i.e. 4, blocks, 8 blocks, 16 blocks, 32 blocks etc. His logic
> is that in this case any space freed up will always be available for
> use and so you won't have any fragmentation.
>
> I'd be grateful for any comments as I'm starting to get more than a
> bit frustrated.
>
> TIA,
>
>
> CE
Received on Fri Jan 10 2003 - 11:34:26 CST
