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 <awells_at_csedge.com> 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_at_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_at_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_at_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_at_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_at_86YY(&%T=&%C:&UE;G0@=&\@=&AI<R!E+6UA:6P@:&%S
>
M(&)E96X@<W=E<'0_at_9F]R('9I<G5S97,N("!792!A8V-E<'0@;F\@;&EA8FEL
>
M:71Y(&9O<B!A;GD_at_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: awells_at_csedge.com
>
> 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: ListGuru_at_fatcity.com (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: hamcdc_at_yahoo.co.uk
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: ListGuru_at_fatcity.com (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).
Received on Thu Oct 10 2002 - 12:14:20 CDT
