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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
