Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id hA9NnP620802 for ; Sun, 9 Nov 2003 17:49:25 -0600 X-ClientAddr: 66.27.56.212 Received: from www3.fatcity.com (rrcs-west-66-27-56-212.biz.rr.com [66.27.56.212]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id hA9NnKc20796 for ; Sun, 9 Nov 2003 17:49:21 -0600 Received: (from root@localhost) by www3.fatcity.com (8.11.6/8.11.6) id hA9KtSt26992 for oracle-l@orafaq.net; Sun, 9 Nov 2003 12:55:28 -0800 Received: by fatcity.com (05-Jun-2003/v1.0g-b73/bab) via fatcity.com id 005D6244; Sun, 09 Nov 2003 12:59:26 -0800 Message-ID: Date: Sun, 09 Nov 2003 12:59:26 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Tanel Poder" Sender: ml-errors@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Tanel Poder" Subject: Re: file sizes over 32GB Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 73; ListGuru (c) 1996-2003 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 7bit The honor should go to Steve Adams, I read it from his website. Tanel. > And we do need education, because we do want to be bricks in the wall. > You seem to know everything, so please, don't leave us alone. > > On 2003.11.07 12:49, Tanel Poder wrote: > > > For reasons why, think about it from the backup/restore > > > perspective. Which database can be backed up or restored > > > faster: one with 100 2Gb datafiles or one with 2 100Gb > > > datafiles? Datafile management is just like extent > > > management. As Roger Waters said, "All in all, they're all > > > just bricks in the wall"... :-) > > > > I don't know whether file system lock contention still applies in modern > > file systems, but the larger the files you are writing in are, the more > > contention you have to file write lock. > > > > Tanel. > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Tanel Poder > > INET: tanel.poder.003@mail.ee > > > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > > San Diego, California -- Mailing list and web hosting services > > --------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > > -- > Mladen Gogala > Oracle DBA > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Mladen Gogala > INET: mgogala@adelphia.net > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: tanel.poder.003@mail.ee Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).