From oracle-l-bounce@freelists.org Tue Nov 2 15:58:39 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id iA2Lwc511886 for ; Tue, 2 Nov 2004 15:58:38 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id iA2LwbI11869 for ; Tue, 2 Nov 2004 15:58:37 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8622572F0B2; Tue, 2 Nov 2004 17:04:50 -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 18105-62; Tue, 2 Nov 2004 17:04:50 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B574172DCFE; Tue, 2 Nov 2004 17:04:43 -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:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=tuEqIq6Pbo5EJzvvaPe0C7mKIAl40cfQWdzejthak+tny4MBHQBQdf//+A6oo8gxe3xgEiwtDCMu1MVjgXKM/zbhPf/t6DwdpTu3JJil3xfhRdTEIPjP4t1GfM7QuO/6gMIBXDIEup08xwAUACogxkUOZa7xOKbU8FENNGGGVTE= Message-ID: Date: Tue, 2 Nov 2004 22:02:25 +0000 From: David Sharples To: oracle-l@freelists.org Subject: Re: datafile size In-Reply-To: <473A9CCD2F80CE4D99A786CB29B0B7CB7E9176@got-exchange.gotcorp.com> Mime-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 8bit References: <473A9CCD2F80CE4D99A786CB29B0B7CB7E9176@got-exchange.gotcorp.com> X-archive-position: 11794 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: davidsharples@gmail.com Precedence: normal Reply-To: davidsharples@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org there really is no practical limit for datafile sizes. The argrument of no more than 2Gb is crass at best. however you dont mention version but recovery is a consideration - do you want to recover a 4gb file or a 20 gb file? (this if you arent doing a full database restore). So up to you what you want keep it is, if you want to increase a file to stop the db from being bounced - i say go for it. I have used 17Gb datafiles before quite happily with no troubles On Tue, 2 Nov 2004 17:01:37 -0500, Daniel Garant wrote: > Hi > > Last week, while creating a new datafile for an expanding tablespace I > received the ORA-00059 (max number of db_file exceeded). The DB is used > in a 24/24 env. So I can't easily plan a bounce to change my db_files > parameter from 151 to 250 for example. > > Now, I'm wondering if the actual datafile size set by the previous DBA > on this DB, which is 4 Gb, is ok or if I could start increasing this > size to 8Gb for example. I normally set my datafile size to be a > portion of the disk size so that I can easily move datafiles around if > needed. But here, the disks are stripped on a big 900 Gb array. So the > need to keep the datafile size down is not really relevant anymore. > > This DB is approx. 600 Gb and growing of approx. 1 Gb every 2 weeks. > > Here are my questions: > > - What would be the best max size for my datafiles? > > - What sizes are you guys using? > > - What should I take into consideration when deciding this? > > Thx in advance > > Daniel > > -- > http://www.freelists.org/webpage/oracle-l > -- http://www.freelists.org/webpage/oracle-l