Oracle-L: RE: Space... confusion

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Thu, 10 Oct 2002 10:18:49 -0800
Message-ID: <F001.004E5FB0.20021010101849@fatcity.com>

April - This is what I hear you saying:

The database was set up on a file system, and there was room to spare.
The file system ran out of space.
Don't know what occurred to take up space, there should have been nothing.
The situation is fixed now. HOW?? If the above is true, I think your best bet may be to attempt to reproduce the problem. But first, carefully measure everything, using something like Unix's "du -k" command. I think that is the only way you will ever pin it down. If you are essentially back to operating again, then get a snapshot now. One thought that just occurred to me, is to check the timestamps. If something changed in size, the timestamp may have changed. I don't believe the Oracle datafiles are updated in a read-only situation. The control file probably gets written to frequently.

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

Is journaling, but journal isn't in that file system, just on the raw part of the volume group

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 11:29 AM To: Multiple recipients of list ORACLE-L

April:

I'm just guessing here, but is it a journaling file system? Could the journal be eating up your available space?

HTH,
Mike

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

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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Vergara, Michael (TEM)
INET: mvergara_at_guidant.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).

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
---------------------------------------------------------------------

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------