Re: LMT advice

foolishHurts wrote:

>We are looking at LMT (finally) and I find two options: Autoallocate
>and uniform.
>
>I find with autoallocate, we are seeing truely huge amounts of extents
>(2000) of very small size (100 KB). While 100 KB seems reasonable for
>small tables, for large tables I would expect extent sizes in the MB
>range.
>
>Question:
>Which is better and why: Uniform (one large, one small) or
>Autoallocate (and ignore extents)?
>
>Also, I can not find the old note where I stored the archive location
>for this newsgroup, so please post that address as well.
>
>Thanks!
>
>Evan
>
>Currently on 8.1.7.4, heading for 9.x as fast as we can drag our
>vendors and customers. <GRIN>
>
>

Use UNIFORM ... it eliminates tablespace fragmentation.

Archive can be viewed through google.com.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)