Re: Allocation type column in DBA

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Mon, 10 Dec 2007 15:56:19 +0100
Message-ID: <475D5393.8060504@gmail.com>

fitzjarrell_at_cox.net schrieb:
> On Dec 10, 8:05 am, Mladen Gogala <mgog..._at_yahoo.com> wrote:

>> When I browsed through the reference manual, I noticed that the
>> allocation type can have the following values: SYSTEM,UNIFORM and USER-
>> SYSTEM is "EXTENT MANAGEMENT LOCAL AUTOALLOCATE". UNIFORM is, of course,
>> EXTENT MANAGEMENT LOCAL UNIFORM SIZE <size>. What the heck is "USER"?
>> I'd like a pointer to the appropriate document, if possible.
>> TIA
>>
>> --
>> Mladen Gogala

>
> Although I can't find it in the documentation at the moment I believe
> USER would be referring to a dictionary-managed tablespace/object
> using the INITIAL, NEXT and PCTINCREASE storage parameters.
>
>
> David Fitzjarrell

According to Note 182679.1 , your suggestion is correct (plus migrated tablespaces).

Best regards

Maxim Received on Mon Dec 10 2007 - 08:56:19 CST

Re: Allocation type column in DBA_TABLESPACES