FWIW, we use 2048m here. --Walt (who feels obligated to make some posts since Steve's off today) Weaver Bozeman, Montana
> -----Original Message----- > From: Jared Still [mailto:[EMAIL PROTECTED] > Sent: Sunday, June 08, 2003 11:00 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: ??? Linux/Oracle 8.1.7 2GB file size limit ??? > > > > Just curious how you arrived at the 1900 meg number. > > Why not use 2000m? > > Oracle defines gigabytes in binary, not decimal as > drive mfg's do, so 2000m would be fine. > > Not a criticism, just wondering. > > Jared > > On Sunday 08 June 2003 09:29, Yechiel Adar wrote: > > We have been hit by a bug in autoextend that corrupted a > database (8.1.6) > > on NT. > > It seems that the bug was exported to Linux as well. > > > > We now use all datafiles with autoextend up to 1900 MB. > > We also define a second datafile with 200MB initial and > autoextend to 1900 > > MB. > > Whenever the last datafile starts to grow we define a new > one with 200MB > > etc. > > > > Seems to work so far. > > > > Yechiel Adar > > Mehish > > ----- Original Message ----- > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > Sent: Wednesday, June 04, 2003 5:40 PM > > > > > I've just been informed that there is a 2GB datafile size > limit with > > > > Oracle 8.1.7 on Linux... PERIOD. This despite the fact that > we've had files > > in excess of this for some time and they work just fine. > The problem occurs > > when the autoextend "feature" reaches the 2GB threshhold. > Of course, Oracle > > didn't tell me this until after about 4 days of back and > forth testing for > > them. (There is no such O/S file size limit.) I've reviewed > the Linux > > release notes, the Linux install guide, the Linux admin > guide and the > > contents of $ORACLE_HOME/relnotes and I don't find any such > limitation in > > the documentation. Did I miss it? Can anyone find any such published > > limitation in the docs? Is this a secret? > > > > > Peeved at Oracle... AGAIN, > > > Steve Orr > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > > -- > > > Author: Orr, Steve > > > 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.net > -- > Author: Jared Still > 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.net -- Author: Weaver, Walt 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).