Thanks Branimir for confirming my right to be peeved. :-) I never liked the autoextend feature but we use it because: 1) We have this "nifty" end user driven feature where they can clone their data via a nice web GUI interface. (This is for web site upgrades scheduled by the end user.) 2) We don't want the user to decide how much disk storage to allocate so we let the datafiles autoextend. 3) As the DBA/DUHveloper (Python/CGI) who "bequeathed" certain DBA functions to the GUI interface, I depended on autoextend working and was too lazy to "algorithm-ize" the number of datafiles based on current storage needs. 4) Upon self-chastizement I'm undoing the autoextend "feature" and am now going to dba_segments to develop a "capacity planning" algorithm.
Developing DBA automation tools driven via events and end user input is a fun and wild ride on the margin of DBA fiefdom. Commiserating with my DBA buddy Walt, "Help... we're losing control and we hate giving up 'power.'" :-) Staring out the window at the mountains in Big Sky Country, Steve -----Original Message----- Sent: Wednesday, June 04, 2003 11:25 AM To: Multiple recipients of list ORACLE-L I'd say file size limit/autoextend feature has been Oracle's dirty little secret for quite a while. For a very long period of time there was similar 4GB 'magic' barrier on Windows, that was allegedly fixed. Workaround for the problem was to create datafile 1 MB larger than the 'magic' number, and ether resize it using this trick or add another datafile to tablespace when the time comes (whenever MagicNumber or N x MagicNumber is close). Despite rumours (of having fixed autoextend feature on Windows) I recently witnessed failed imports into Oracle 9.2.0.1.0 caused by too small tablespaces that just wouldn't autoextend. Interestingly, import died "beautifully" cuz silently in the middle of job without _any_ errors, traces etc. Just gone. There is also interesting myth here at the place where I work that systems tablespace autoextend feature ain't to be trusted as "it is known" to have caused intermittent data dictionary corruptions while code recompilation takes place under space "crunch" conditions... On slightly cynical side note: autoextend that doesn't - maps nicely into job safety ;-) Branimir > -----Original Message----- > From: Orr, Steve [mailto:[EMAIL PROTECTED] > Sent: June 4, 2003 11:40 AM > To: Multiple recipients of list ORACLE-L > Subject: ??? Linux/Oracle 8.1.7 2GB file size limit ??? > > > 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: Branimir Petrovic 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: 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).
