Re: Locally Managed Tablespaces
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: Nagarajan.Subbiah@xxxxxxxx
- Date: Thu, 20 Jan 2005 20:29:57 +0000
On Thu, 20 Jan 2005 15:12:25 -0500, Subbiah, Nagarajan
<Nagarajan.Subbiah@xxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
