That could be quite a LARGE update.. ;) -----Original Message----- Carmichael Sent: 05 June 2003 01:49 To: Multiple recipients of list ORACLE-L
geez, back to the very very first presentation Marlene Theriault and I did together, about version 6, called "All the Things THEY Didn't Tell You" you mean I hafta update it AGAIN????????? :) --- "Orr, Steve" <[EMAIL PROTECTED]> wrote: > And thanks for the note recommendation Dennis... > > There's too many of these bullets flying around. Need a short list > called: "Things you should know that Oracle doesn't tell you straight > out." > > Of course there's the bug list but who has time for that and can > remember it all? Sigh... > > > Steve > > > -----Original Message----- > Sent: Wednesday, June 04, 2003 4:40 PM > To: Multiple recipients of list ORACLE-L > > > Steve > Personally I am VERY glad you mentioned this today. Since I run > 64-bit > Unix, I didn't think this applied to me, but after reading the note, > I ran > their formula and found a file on one of my databases that was very > close to > the limit. Plenty happy to dodge that bullet. > > Dennis Williams > DBA, 80%OCP, 100% DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -----Original Message----- > Sent: Wednesday, June 04, 2003 4:15 PM > To: Multiple recipients of list ORACLE-L > > > We are on 8.1.7.4 and it aflicted us anyway. Maybe I'll just wait a > couple > of years and let other customers QA this Oracle feature until they > get it > right. > > > Steve > > > -----Original Message----- > Sent: Wednesday, June 04, 2003 2:35 PM > To: Multiple recipients of list ORACLE-L > > > Ahem . . . according to Note 112011.1, "these problems can affect all > platforms except OS/390 which does NOT support datafile resizing" > (fiendishly clever those mainframe types). > It looks like 8.1.7.4 and above is not affected. I would highly > recommend > that all Oracle DBAs take a look at this note. > > Dennis Williams > DBA, 80%OCP, 100% DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -----Original Message----- > Sent: Wednesday, June 04, 2003 3:00 PM > To: Multiple recipients of list ORACLE-L > > > It doesn't seem to be a problem on other platforms... Just when I > stopped > feeling like a neglected step child for running on Linux. Don't > worry... Be > happy... There's a workaround... Upgrade and buy more software... > > D'ai jobu desu... er, eh, Ca ne fais rien. > > > -----Original Message----- > Sent: Wednesday, June 04, 2003 12:46 PM > To: Multiple recipients of list ORACLE-L > > > This almost sounds like the problem that existed for Oracle 7.3 and > the 2G > threshold a couple of years ago... > > J'ai une impression d'avoir dij` vu ceci. > > : ) > > Patrice. > > -----Original Message----- > Sent: Wednesday, June 04, 2003 3:10 PM > To: Multiple recipients of list ORACLE-L > > > Steve - are you saying that there is a workaround by increasing the > size of > the file manually to something larger than 4G? > > Tom Mercadante > Oracle Certified Professional > > > -----Original Message----- > Sent: Wednesday, June 04, 2003 1:25 PM > To: Multiple recipients of list ORACLE-L > > > See my note: "There is no such O/S file size limit." > > We have datafiles > 2GB which work just fine. The problem is with > autoextending datafiles that extend from <2GB to >2GB. It's not a > Linux > limitation but a limitation imposed by Oracle's implementation on > Linux. > Oracle 9i on Linux doesn't have this problem. And my peeve is that it > took > OWS 4 days to "discover" this "limit." > > > Still peeved, :-) > Steve > > > > -----Original Message----- > Sent: Wednesday, June 04, 2003 10:55 AM > To: Multiple recipients of list ORACLE-L > > > I think it is the limitation of Linux, not Oracle. > Use LVM and don't worry about file size limit. :-) > > JP > ----- 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: Jan Pruner > 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 > -- > === message truncated === __________________________________ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.484 / Virus Database: 282 - Release Date: 27/05/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.484 / Virus Database: 282 - Release Date: 27/05/2003 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith 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).