Message-ID: <F001.004E5E13.20021010091420@fatcity.com>
Date: Thu, 10 Oct 2002 09:14:20 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
Sender: root@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: =?iso-8859-1?q?Connor=20McDonald?= <hamcdc@yahoo.co.uk>
Subject: Re: Space... confusion
Organization: Fat City Network Services, San Diego, California
Precedence: bulk
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

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@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@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: awells@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@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@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@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).