DO NOT USE AUTOEXTEND on these datafiles. There is a bug when datafile autoextend into 2GB or 4GB (I do not remember exactly now) on NT. We had a database down permanently because of this.
We do not work with any X OS here so I am talking about NT only. Yechiel Adar Mehish ----- Original Message ----- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Monday, June 09, 2003 7:34 PM > 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yechiel Adar 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).