Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Space... confusion

RE: Space... confusion

From: April Wells <awells_at_csedge.com>
Date: Thu, 10 Oct 2002 11:50:06 -0800
Message-ID: <F001.004E616C.20021010115006@fatcity.com>


At the OS level, the files are 4000 meg. If they are created sparse, would it show at the OS level?

April Wells
Oracle DBA
Keep yourself well oiled with life, laughter, new ideas and action. Otherwise you will rust out. _Anonymous

-----Original Message-----
Sent: Thursday, October 10, 2002 12:14 PM To: Multiple recipients of list ORACLE-L

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

begin 666 InterScan_Disclaimer.txt

MM                                       5&AE(&EN9F]R;6%T:6]N
M(&-O;G1A:6YE9"!I;B!T:&ES(&4M;6%I;"!I<R!SM                   
M                    =')I8W1L>2!C;VYF:61E;G1I86P_at_86YD(&9O<B!T
M:&4@:6YT96YD960@=7-EM                                       
M(&]F('1H92!A9&1R97-S964@;VYL>3L@:70@;6%Y(&%L<V\@8F4@;&5G86QL
MM                                       >2!P<FEV:6QE9V5D(&%N
M9"]O<B!P<FEC92!S96YS:71I=F4N("!.;W1I8V4_at_M                   
M                    :7,@:&5R96)Y(&=I=F5N('1H870_at_86YY(&1I<V-L
M;W-U<F4L('5S92!O<B!CM                                       
M;W!Y:6YG(&]F('1H92!I;F9O<FUA=&EO;B!B>2!A;GEO;F4@;W1H97(@=&AA
MM                                       ;B!T:&4@:6YT96YD960@
M<F5C:7!I96YT(&ES('!R;VAI8FET960_at_86YD(&UA M>2!B92!I;&QE9V%L+B
MM                    @268@>6]U(&AA=F4@<F5C96EV960@=&AI<R!M97
MM                                       86=E(&EN(&5R<F]R+"!P
M;&5A<V4@;F]T:69Y('1H92!S96YD97(@:6UM961IM                   
M                    871E;'D_at_8GD@<F5T=7)N(&4M;6%I;"X*"D-O<G!O
M<F%T92!3>7-T96US+"!)M                                       
M;F,N(&AA<R!T86ME;B!E=F5R>2!R96%S;VYA8FQE('!R96-A=71I;VX@=&\@
MM                                       96YS=7)E('1H870_at_86YY
M(&%T=&%C:&UE;G0@=&\@=&AI<R!E+6UA:6P@:&%SM                   
M                    (&)E96X@<W=E<'0_at_9F]R('9I<G5S97,N("!792!A
M8V-E<'0@;F\@;&EA8FELM                                       
M:71Y(&9O<B!A;GD_at_9&%M86=E('-U<W1A:6YE9"!A<R!A(')E<W5L="!O9B!S
MM                                       ;V9T=V%R92!V:7)U<V5S
M(&%N9"!A9'9I<V4@>6]U(&-A<G)Y(&]U="!Y;W5RM                   
M                    (&]W;B!V:7)U<R!C:&5C:W,@8F5F;W)E(&]P96YI
M;F<@86YY(&%T=&%C:&UE +;G0N#0H-"@T*#0H M                     
M %.$M                                    M                  
M                     -- M                                   
M P,%!3% 3%% 4(% /&&)#)!, ORACLE-L FAQ:M  (440://777./2!&!1.#
M/-M                  -- M                                   
M A54(/2: A02), W%,,3M                      INET: !7%,,3@#3%$
M'%.#/-M              M                                      
M F!4 C)49 N%47/2+ S%26)#%3    -- 858-538 (440://777.&!4#)49.
M#/-M                 S!. D)%'/, C!,)&/2.)!        -- M!),).'
M (/34).' 3%26)#%3M                      M                   
M                    ----------------- -#P,I;;]I0&3U4DQ3!@!DC
MS0%""4P#023"3AP#"0)3;023 #14TP1Q;0                        %#
MV@+"4U)U4E8!@5 R5&3_at_SS0"#CU!0)>(8] $T !["4U)U4E1R0 3A "3K0  
M                  %"!0#14TP1Q0(KY.3 "3_at_S%1!0 0#"3A0 SSE 20+\
MH8[)3;+0                              "#T@%"!0#@310#Q@#023"3
MAP#"4U &3U0%P3E % !DCS23@ .3U0#06;0                        3
M$SP$Q3A %"!0*);,  SS303A !CT@#U"!4@"3@"#"2Q0$U0DPTB0B3AR3@+0
M                                                            
M                 '777;0                                 /../
M2 M#D/.!,$M                               !11!H\]==<XU%$&CSU
MUUSC                                                        
M    R%,                                                     
M      #________________________________________________^T   
M                               \#D]4#D$@\\%^T               
M                  !85)E0_at_DX<!D]4<PP 585( X440 \X \X4!<4(! $<
M6T      2/- N%73440://5+.-8T"T              ,%!3% 3%% 4(% /&
M&)#)!, ORACLE-L FAQ: (440://777./2!&!1.#/-M     - M         
M     %5"#TF@'7R4SS6&%6347T7XSSCCTG4D+0Y#S_at_3!'W;0 %1H92!I;F9O
M<FUA=&EO;B!C;VYT86EN960@:6X@=&AI<R!E+6UA:6P@:7,@<W1R:6-T;'D@ M8V]N9FED96YT:6%L(&%N9"!F;W(@=&AE(&EN=&5N9&5D('5S92!O9B!T:&4@ M861D<F5S<V5E(&]N;'D[(&ET(&UA>2!A;'-O(&)E(&QE9V%L;'D@<')I=FEL M96=E9"!A;F0O;W(@<')I8V4@<V5N<VET:79E+B @3F]T:6-E(&ES(&AE<F5B M>2!G:79E;B!T:&%T(&%N>2!D:7-C;&]S=7)E+"!U<V4@;W(@8V]P>6EN9R!O M9B!T:&4@:6YF;W)M871I;VX_at_8GD@86YY;VYE(&]T:&5R('1H86X@=&AE(&EN M=&5N9&5D(')E8VEP:65N="!I<R!P<F]H:6)I=&5D(&%N9"!M87D_at_8F4@:6QL M96=A;"X@($EF('EO=2!H879E(')E8V5I=F5D('1H:7,@;65S<V%G92!I;B!E M<G)O<BP@<&QE87-E(&YO=&EF>2!T:&4@<V5N9&5R(&EM;65D:6%T96QY(&)Y M(')E='5R;B!E+6UA:6PN"@I#;W)P;W)A=&4_at_4WES=&5M<RP_at_26YC+B!H87,@ M=&%K96X_at_979E<GD@<F5A<V]N86)L92!P<F5C875T:6]N('1O(&5N<W5R92!T
M:&%T(&%N>2!A='1A8VAM96YT('1O('1H:7,@92UM86EL(&AA<R!B965N('-W
M97!T(&9O<B!V:7)U<V5S+B @5V4_at_86-C97!T(&YO(&QI86)I;&ET>2!F;W(@
M86YY(&1A;6%G92!S=7-T86EN960_at_87,@82!R97-U;'0@;V8@<V]F='=A<F4@
M=FER=7-E<R!A;F0_at_861V:7-E('EO=2!C87)R>2!O=70@>6]U<B!O=VX@=FER M=7,@8VAE8VMS(&)E9F]R92!O<&5N:6YG(&%N>2!A='1A8VAM96YT+@T*#0H- %"@T*#0H
end
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).
-- 
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).
Received on Thu Oct 10 2002 - 14:50:06 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US