Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!news.mel.connect.com.au!news-south.connect.com.au!news-north.connect.com.au!newsfeed.iinet.net.au!newsfeed.iinet.net.au!per-qv1-newsreader-01.iinet.net.au!not-for-mail
Message-ID: <4200DAEF.7F47@yahoo.com>
Date: Wed, 02 Feb 2005 21:51:43 +0800
From: Connor McDonald <connor_mcdonald@yahoo.com>
Reply-To: connor_mcdonald@yahoo.com
X-Mailer: Mozilla 3.01 (WinNT; I)
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server
Subject: Re: Extent Management in SYSTEM tablespace
References: <1107241855.895544.119680@c13g2000cwb.googlegroups.com>
	   <41FF89FB.3537@yahoo.com> <1107298251.271647.198850@z14g2000cwz.googlegroups.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 42
NNTP-Posting-Host: 203.59.158.217
X-Trace: 1107352306 per-qv1-newsreader-01.iinet.net.au 6400 203.59.158.217
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:234797

Joel Garry wrote:
> 
> >DMT is dead...
> 
> And like fish and visiting relatives, should be thrown out after 3
> days.  (Finally convinced a stick-in-the-mud customer to let me get rid
> of them this past weekend.)
> 
> Did anyone ever come up with a reference or refute for the statement
> that all the LMT extent sizes internally use 64K extents despite what
> oracle reports?
> 
> jg
> --
> @home.com is bogus.
> "My head is *spinning*...but I am willing to bet my savings right now
> that the next reincarnation of HTMLDB is gonna end up in the next AS
> like
> WebDB...Portal...Anyone wanna bet against me ? :) " - Robert from CT
> "I will." - Tom Kyte

For uniform you'll see 1 bit per extent size nominated in the datafile
dumps.  For auto, you'll see 1 bit per 64k

there's an article on www.oaktable.net of mine about it

hth
connor
-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald@yahoo.com


"GIVE a man a fish and he will eat for a day. But TEACH him how to fish,
and...he will sit in a boat and drink beer all day"

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