From oracle-l-bounce@freelists.org Thu Jan 20 20:54:49 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j0L2snpr021965 for ; Thu, 20 Jan 2005 20:54:49 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j0L2smxu021959 for ; Thu, 20 Jan 2005 20:54:48 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4516D72C5E7; Thu, 20 Jan 2005 20:54:07 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 11464-22; Thu, 20 Jan 2005 20:54:07 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id ECF4C72C9F7; Thu, 20 Jan 2005 20:50:26 -0500 (EST) Message-ID: <20050121014605.35297.qmail@web86908.mail.ukl.yahoo.com> Date: Fri, 21 Jan 2005 01:46:05 +0000 (GMT) From: Connor McDonald Subject: Re: Locally Managed Tablespaces To: oracle-l@freelists.org In-Reply-To: <41F01D1C.80704@centrexcc.com> MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-archive-position: 15066 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: hamcdc@yahoo.co.uk Precedence: normal Reply-To: hamcdc@yahoo.co.uk X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org X-Spam-Status: No, hits=0.0 required=5.0 tests=none autolearn=ham version=2.60 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com I'll be happy with auto when Oracle publish the extent size algorithm. Sure we can work it out roughly - but if its not published, then by definition, its impossible to guarantee that a tablespace has sufficient space for a segment to extend. eg lets say Oracle change their algorithm to skip the 8m extent size, so it goes 64k,1m,64m. You might have a tablespace with 60M free space in it, and you'll happily be thinking "yep, that one is ok" and then BAMM! Users start getting 'unable to extend errors' Cheers Connor --- Wolfgang Breitling wrote: > I do not overly worry about the number of extents either - at least not > as long as I can grasp them with one look without having to divide them > into groups of 3. What I do worry about is the rate at which extents get > added and if you have transaction tables (as opposed to more static > setup or warehouse type tables) you likely have a growth pattern which > is correlated to the size (or probably more accurately vice versa). I > like to size the uniform extents such that a growing table adds between > 1-30 extents per month (anywhere between once a month and once a day, > although the latter is already too much for my liking). > > I'll have to read that ask tom link. > > Niall Litchfield wrote: > > > > > I guess my bias is that I really, really don't care how many extents > > my segment has (at least if I did have tens of thousands i'd be > > worrying about partitioning instead) and so I see no reason to use > > auto. > > > -- > Regards > > Wolfgang Breitling > Centrex Consulting Corporation > www.centrexcc.com > -- > http://www.freelists.org/webpage/oracle-l > ===== Connor McDonald Co-author: "Mastering Oracle PL/SQL - Practical Solutions" ISBN: 1590592174 web: http://www.oracledba.co.uk web: http://www.oaktable.net email: connor_mcdonald@yahoo.com Coming Soon! "Oracle Insight - Tales of the OakTable" "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" ------------------------------------------------------------ __________________________________ Do you Yahoo!? The all-new My Yahoo! - Get yours free! http://my.yahoo.com -- http://www.freelists.org/webpage/oracle-l