Re: Extent Management in SYSTEM tablespace

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_at_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"

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