Tablespace Allocation Type & Extent Management

From: Walter K <alden14004_at_yahoo.com>
Date: Thu, 31 May 2001 14:20:39 -0700
Message-ID: <F001.00316C92.20010531130709@fatcity.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  <---

????

As always, your feedback is ALWAYS appreciated.
-w

Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Walter K
INET: alden14004_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu May 31 2001 - 16:20:39 CDT