Re: Locally Managed Tablespaces

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Thu, 20 Jan 2005 20:29:57 +0000
Message-ID: <7765c897050120122940b8f7b3@mail.gmail.com>

On Thu, 20 Jan 2005 15:12:25 -0500, Subbiah, Nagarajan <Nagarajan.Subbiah_at_aetn.com> wrote:
> Is the Uniform allocation has any advantageous than SYSTEM allocation type?
> Does the SYSTEM allocation type has any issues?
>
> Raja.

With uniform allocation you cannot get free space fragmentation problems, with system managed you can (but are unlikely to).

With uniform allocation if you guess^H^H^H^H calculate the segment size wrongly you can end up with very large or very small numbers of extents.

I prefer and have long advocated uniform extent sizing, others have advocated a system policy.

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jan 20 2005 - 15:37:13 CST