Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Locally Managed Tablespaces
Subbiah, Nagarajan wrote:
>Is the Uniform allocation has any advantageous than SYSTEM allocation type?
>Does the SYSTEM allocation type has any issues?
>
>Raja.
>
>
>
Tablespaces with uniform allocation cannot be fragmented, while system
allocation allows fragmentation.
A case like that was constructed by Jonathan or Gopal, I believe. System
allocation is allows only discrete and
very finite extent sizes, but can be brought into state where no
extents of larger sizes are left, which is what is known
as "fragmentation" (although, strictly speaking, it is not fragmentation).
-- Mladen Gogala Oracle DBA -- http://www.freelists.org/webpage/oracle-lReceived on Thu Jan 20 2005 - 16:47:14 CST
![]() |
![]() |