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

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

Niall Litchfield
Oracle DBA

Other related posts: