Are you using tempfiles ? Just a hypothesis: Tempfiles are created sparse, so you ask for 100M, but in reality only 1M might be allocated. As people sort, you actually start needing the 100M and kapow!
hth connor --- April Wells <[EMAIL PROTECTED]> wrote: > Please forgive the cross postings, but I am hoping > that someone in all of > the sets of eyes that see this might have an idea I > haven't thought of. > *** > Facts > ************************************** > aix 4.3.3 > oracle 9.0.1.3 > new instance, up for 2 weeks > locally managed tablespaces > nothing with autoextend on > file system at 7:01 am was at 98% > 12:00 altered index tablespaces to nologging (but > this did not change the > file sizes... checked) > 12:30 users (it is not a transactional instance... > it is strictly reporting) > started getting Ora-01114 errors corresponding > (roughly) to when the file > system hit 100% > The only thing in the file system are database files > Nothing "could" have changed at OS level in that > time..........to my > knowledge > ITAR open, not much progress (re... "that can't > happen") > **************************************************** > > DID happen... now trying desperately to find out WHY > it happened. The > 'problem' effected our biggest client. I need to > find out what happened so > it doesn't happen again... > > File system now at 92%, but will need to add dasd in > the near future for > growth > > one interesting finding found in the digging > 9i created files of 2000m are 2097168384 k at os > level > 8i created and upgraded to 9i files of 2000m are > 2097156096 at os level... > > Anybody have any ideas how something that can't > happen, did? Anyone ever > seen this kind of weirdness before? > > > April Wells > Oracle DBA > Keep yourself well oiled with life, laughter, new > ideas and action. > Otherwise you will rust out. _Anonymous > > > > begin 666 InterScan_Disclaimer.txt > M5&AE(&EN9F]R;6%T:6]N(&-O;G1A:6YE9"!I;B!T:&ES(&4M;6%I;"!I<R!S > M=')I8W1L>2!C;VYF:61E;G1I86P@86YD(&9O<B!T:&4@:6YT96YD960@=7-E > M(&]F('1H92!A9&1R97-S964@;VYL>3L@:70@;6%Y(&%L<V\@8F4@;&5G86QL > M>2!P<FEV:6QE9V5D(&%N9"]O<B!P<FEC92!S96YS:71I=F4N("!.;W1I8V4@ > M:7,@:&5R96)Y(&=I=F5N('1H870@86YY(&1I<V-L;W-U<F4L('5S92!O<B!C > M;W!Y:6YG(&]F('1H92!I;F9O<FUA=&EO;B!B>2!A;GEO;F4@;W1H97(@=&AA > M;B!T:&4@:6YT96YD960@<F5C:7!I96YT(&ES('!R;VAI8FET960@86YD(&UA > M>2!B92!I;&QE9V%L+B > @268@>6]U(&AA=F4@<F5C96EV960@=&AI<R!M97-S > M86=E(&EN(&5R<F]R+"!P;&5A<V4@;F]T:69Y('1H92!S96YD97(@:6UM961I > M871E;'D@8GD@<F5T=7)N(&4M;6%I;"X*"D-O<G!O<F%T92!3>7-T96US+"!) > M;F,N(&AA<R!T86ME;B!E=F5R>2!R96%S;VYA8FQE('!R96-A=71I;VX@=&\@ > M96YS=7)E('1H870@86YY(&%T=&%C:&UE;G0@=&\@=&AI<R!E+6UA:6P@:&%S > M(&)E96X@<W=E<'0@9F]R('9I<G5S97,N("!792!A8V-E<'0@;F\@;&EA8FEL > M:71Y(&9O<B!A;GD@9&%M86=E('-U<W1A:6YE9"!A<R!A(')E<W5L="!O9B!S > M;V9T=V%R92!V:7)U<V5S(&%N9"!A9'9I<V4@>6]U(&-A<G)Y(&]U="!Y;W5R > M(&]W;B!V:7)U<R!C:&5C:W,@8F5F;W)E(&]P96YI;F<@86YY(&%T=&%C:&UE > +;G0N#0H-"@T*#0H > end > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: April Wells > 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). ===== Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net "Remember amateurs built the ark - Professionals built the Titanic" __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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).