Noons and Alistair are correct. Also look at Tom's site
(asktom.oracle.com). He has a lot of good reasons.
Jim
--
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family. Remove the negative part, keep the minus sign. You can figure
it out.
"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 - 09:45:19 CST
