Datafile sizing affects the speed of backup and restore, since each datafile can only be backed up or restored by one process at a time. As a result, I try to keep datafiles at uniform sizes of 2-4 Gb max. How do such large and variable-sized datafiles impact your backups and restores? Just curious...
----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, September 26, 2002 6:28 AM > Yes, 10Gb datafiles. > I think we have a 35Gb datafile somewhere but I have not looked at that > database myself > > John > > -----Original Message----- > Sent: 26 September 2002 12:03 > To: Multiple recipients of list ORACLE-L > > > 10001Mb? > > the uniform extent sizes map to what I'll be using as well. good to > know I'm not way off track > > --- [EMAIL PROTECTED] wrote: > > We tend to use multiples of 1Gb and add 1 Mb to the file so that we > > get > > 2001, 10001 Mb etc > > Solaris 2.8 > > LMT uniform extents range from 64K to 20Mb > > > > John > > > > -----Original Message----- > > Sent: 25 September 2002 19:44 > > To: Multiple recipients of list ORACLE-L > > > > > > > > We created two datafiles of 16GB+64K all LMT autoallocate ... never > > gave a > > problem. A basic testing concluded that fixed size allocation of 128M > > caused > > unnecessary delays whereas autoallocate was much faster. I don't know > > the > > full details yet, but I'll know soon. > > > > Of course this is undergoing lot of testing (the whole application, > > no > > problems with datafiles yet), but we will probably settle for about > > 4GB+64K. > > This is AIX5L 64 bit running Oracle 9iR2. > > > > Raj > > ______________________________________________________ > > Rajendra Jamadagni MIS, ESPN Inc. > > Rajendra dot Jamadagni at ESPN dot com > > Any opinion expressed here is personal and doesn't reflect that of > > ESPN Inc. > > > > QOTD: Any clod can have facts, but having an opinion is an art! > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: > > INET: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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). > > > __________________________________________________ > Do you Yahoo!? > New DSL Internet Access from SBC & Yahoo! > http://sbc.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rachel Carmichael > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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.com > -- > Author: > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).