From oracle-l-bounce@freelists.org Fri Jan 28 19:18:43 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j0T1Ih1u025247 for ; Fri, 28 Jan 2005 19:18:43 -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 j0T1Ihem025243 for ; Fri, 28 Jan 2005 19:18:43 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A15C1682B3; Fri, 28 Jan 2005 19:17:53 -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 19492-05; Fri, 28 Jan 2005 19:17:53 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 24B9968683; Fri, 28 Jan 2005 19:17:53 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=XxUUu2eyqRcmP0HLAZI63KtmZtf0EerflS31tR05hPs3gYGMpS3J8GpC+MigSrP/MNyv198VSiBMTJqb0s5b88u6ogUmawuyHVAhl8g5AmCeDkwlKoibGBbzch+QBHTlXP8Fkc89G8G4D5xDjuq/AzQih3ZxuTdnEwsf0/yc+rI= Message-ID: <687bf9c405012816166e299709@mail.gmail.com> Date: Sat, 29 Jan 2005 00:16:12 +0000 From: stephen booth To: juancarlosreyesp@gmail.com Subject: Re: Many small ones or one big one. Cc: ltiu@alumni.sfu.ca, Oracle-L@freelists.org In-Reply-To: Mime-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 8bit References: <41FAC21A.8010606@alumni.sfu.ca> X-archive-position: 15451 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: stephenbooth.uk@gmail.com Precedence: normal Reply-To: stephenbooth.uk@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at example.com X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com X-Spam-Status: No, hits=0.1 required=5.0 tests=AWL autolearn=ham version=2.60 X-Spam-Level: I had to fix a problem last week where, in a 64bit Solaris 9 box, someone had created a tablespace with with four 30Gb datafiles. Unfortunately the backup device attached to that server had a maximum capacity of about 20Gb per tape and the backup software couldn't split large files over multiple tapes (and you really wouldn't want to). Also the projected datavolumes for the first year on this system are around 3GB. I'm all for allowing room for future growth, but there's room for future growth and then there's being a bit daft. That tablespace now has three 2Gb datafiles. Stephen -- It's better to ask a silly question than to make a silly assumption. -- http://www.freelists.org/webpage/oracle-l