Path: news.easynews.com!easynews!feed2.onemain.com!feed1.onemain.com!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!news1.optus.net.au!optus!spool01.syd.optusnet.com.au!spool.optusnet.com.au!210.49.20.118.MISMATCH!not-for-mail Reply-To: "Howard J. Rogers" From: "Howard J. Rogers" Newsgroups: comp.databases.oracle.server References: <77e87b58.0105220927.432b49d8@posting.google.com> <3B0BCADE.7C28@yahoo.com> <3BEEA607.E4CC5761@ecis.com> Subject: Re: LMT with autoallocate Date: Mon, 12 Nov 2001 06:26:05 +1100 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Lines: 49 Message-ID: <3beed0db$0$5037$afc38c87@news.optusnet.com.au> NNTP-Posting-Host: 210.49.119.239 X-Trace: 1005506779 5037 210.49.119.239 Xref: easynews comp.databases.oracle.server:124602 X-Received-Date: Sun, 11 Nov 2001 18:15:53 MST (news.easynews.com) There's nothing particularly wrong with 'autoallocate', except that one of the main reasons for moving to local management in the first place is that they can guarantee absolutely consistent extent sizes within the tablespace, and thus forever eliminate the possibility of tablespace fragmentation. Autoallocate guarantees precisely the opposite: a mixed set of extent sizes as the table grows, and hence a distinct chance of future fragmentation. It's also the same argument about PCTINCREASE... it's a great saver for those who can't get their segments sized properly in the first place, but you *ought* to be able to size your segments properly! Regards HJR -- Resources for Oracle: http://www.hjrdba.com =============================== "Mark Bole" wrote in message news:3BEEA607.E4CC5761@ecis.com... > I have seen several times the recommendation to only use uniform extents with LMT > instead of "autoallocate", but no explanation as to why? > > We have been using LMT with autoallocate for a long time (admittedly not a huge DB) > with no problems... > > Connor McDonald wrote: > > > Thomas Kyte wrote: > > > > > [...] > > > > > > > >Could someone who has used LMT (locally managed tablespaces) with > > > >either autoallocate or uniform extents comment on their alleged > > > >performance benefits, administrative issues, etc? > > > > > > [...] > > > > > > locally managed tablespaces are (with the glaring exception of system) the ONLY > > > type of tablespace I use. I only use UNIFORM, never autoallocate. > > > > > [...] >