Re: LMT advice

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: Sun, 28 Sep 2003 01:29:37 +1000
Message-ID: <3f75af16$0$2471$afc38c87@news.optusnet.com.au>

"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:3f75a9fc$0$9828$afc38c87_at_news.optusnet.com.au...

>

> ASSM = 'create tablespace blah... segment space management auto'
> Autoallocate = 'create tablespace blah...extent management local
> autoallocate'
> ASSM deals with when a block becomes available for an insert. Autoallocate
> merely sizes extents automatically for you.

Aren't they one and the same in 10g? I got the distinct impression from KJ's talk that was the case.

Isn't ASSM supposed to end the problem with hot spots in inserts as well?

> The one is the invention of the devil (OK, I exaggerate slightly) and the
> other is a gift from Heaven (well, OK, ditto).

Not that there is anything wrong with that! :)

-- 
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam

Received on Sat Sep 27 2003 - 10:29:37 CDT