+ Reply to Thread
Results 1 to 5 of 5

Allocation type column in DBA_TABLESPACES

  1. Allocation type column in DBA_TABLESPACES

    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 . What the heck is "USER"?
    I'd like a pointer to the appropriate document, if possible.
    TIA



    --
    Mladen Gogala

  2. Re: Allocation type column in DBA_TABLESPACES

    On Dec 10, 8:05 am, Mladen Gogala 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 . 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

  3. Re: Allocation type column in DBA_TABLESPACES

    fitzjarrell@cox.net schrieb:
    > On Dec 10, 8:05 am, Mladen Gogala 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 . 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

  4. Re: Allocation type column in DBA_TABLESPACES

    On Dec 10, 8:56 am, Maxim Demenko wrote:
    > fitzjarr...@cox.net schrieb:
    >
    >
    >
    >
    >
    > > On Dec 10, 8:05 am, Mladen Gogala 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 . 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- Hide quoted text -
    >
    > - Show quoted text -


    Thank you for the Metalink reference.


    David Fitzjarrell

  5. Re: Allocation type column in DBA_TABLESPACES

    On Mon, 10 Dec 2007 15:56:19 +0100, Maxim Demenko wrote:

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


    Thanks, Maxim!



    --
    Mladen Gogala

+ Reply to Thread