Path: news.easynews.com!easynews!crtntx1-snh1.gtei.net!lsanca1-snf1!news.gtei.net!newsfeed2.earthlink.net!newsfeed.earthlink.net!newsmaster1.prod.itd.earthlink.net!newsread1.prod.itd.earthlink.net.POSTED!not-for-mail From: "Mladen Gogala" Subject: Re: LMT with autoallocate Newsgroups: comp.databases.oracle.server Message-ID: References: <77e87b58.0105220927.432b49d8@posting.google.com> <3B0BCADE.7C28@yahoo.com> <3BEEA607.E4CC5761@ecis.com> <9smaja02rfi@drn.newsguy.com> User-Agent: Pan/0.10.0 (Unix) Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Comment-To: "Thomas Kyte" Lines: 33 Date: Mon, 12 Nov 2001 04:04:53 GMT NNTP-Posting-Host: 158.252.37.238 X-Complaints-To: abuse@earthlink.net X-Trace: newsread1.prod.itd.earthlink.net 1005537893 158.252.37.238 (Sun, 11 Nov 2001 20:04:53 PST) NNTP-Posting-Date: Sun, 11 Nov 2001 20:04:53 PST Organization: EarthLink Inc. -- http://www.EarthLink.net Xref: easynews comp.databases.oracle.server:124620 X-Received-Date: Mon, 12 Nov 2001 03:22:54 MST (news.easynews.com) In article <9smaja02rfi@drn.newsguy.com>, "Thomas Kyte" wrote: > In article <3BEEA607.E4CC5761@ecis.com>, Mark says... >> >>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... >> >> > I just like the uniform sizes - I group objects by their size, hence I > can set up an extent size that makes sense. I'll put "big things" in > "big tablespaces", "small things" in small tablespaces. > > The autoallocate sort of says "I don't know or care how big the objects > will be, so, start them off small and make the extents get bigger and > bigger as time goes on". > > Since I generally know how big things will be or how they are to grow > over time, I just put them in the right bucket by size. > I am paid to be paranoid and I do not believe the functional specifications because things sometimes turn out to be an order of magnitude larger then planned. I do like LMT with autoallocate. On the other hand, I'm just a production DBA, other people can have different views. -- Mladen Gogala We are the DBAs. Resistance is futile. You will be denormalized.