Re: Pros/Cons of LMT

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 11 Jul 2001 18:52:24 +0100
Message-ID: <3B4C9258.4FF6@yahoo.com>

Terry Dykstra wrote:
>
> Locally managed tablespaces seem like the way to go. What are some of the
> mean reasons for using / not using them.
>
> --
> Terry Dykstra
> Canadian Forest Oil Ltd.

Benefits are numerous - fragmentation, dictionary contention...

drawback (imho) are pretty much none - just don't go too heavy on dba_extents or dba_segments

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."

Received on Wed Jul 11 2001 - 12:52:24 CDT