RE: Tablespace Allocation Type & Extent Management

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Thu, 31 May 2001 20:25:21 -0700
Message-ID: <F001.0031751E.20010531200021@fatcity.com>

> -----Original Message-----
> From: Walter K [mailto:alden14004_at_yahoo.com]
>
> I seem to be confused about the relationship between
> tablespace management and allocation methods.
>
> What is the USER allocation_type (as reported by
> DBA_TABLESPACES)? I thought this corresponded only to
> dictionary-managed tablespaces--I see it associated
> with locally-managed tablespaces as well.
>
> Also, I thought that PCTINCREASE was only applicable
> to dictionary-managed tablespaces. Again, I am seeing
> a PCT_INCREASE=50 for some locally-managed tablespaces
> in one of my databases. How is this possible?
>
> Based on everything I have read (docs & metalink)
> about LMTs vs. Dictionary, I am perplexed by the
> results of the following query I ran:
>

>   1  select extent_management, allocation_type,

> pct_increase, count(*)

>   2  from dba_tablespaces
>   3  group by extent_management, allocation_type,

> pct_increase;
>
> EXTENT_MAN ALLOCATIO PCT_INCREASE   COUNT(*)
> ---------- --------- ------------ ----------
> DICTIONARY USER                 0          4
> DICTIONARY USER                50          3
> LOCAL      SYSTEM                          1
> LOCAL      UNIFORM              0          1
> LOCAL      USER                50        283  <---
> ????

How did you create that tablespace? I have a test database (Oracle 8.1.6 on Windows 2000) where I have tried to create a tablespace of every possible kind, and I don't have a tablespace with EXTENT_MANAGEMENT = 'LOCAL' and ALLOCATION_TYPE = 'USER'. What's your secret?

---

Jacques R. Kilchoer
(949) 754-8816
Quest Software, Inc.
8001 Irvine Center Drive
Irvine, California 92618
U.S.A.
http://www.quest.com Received on Thu May 31 2001 - 22:25:21 CDT