Re: Space... confusion

Probably due to tempfiles in your TEMPORARY tablespace...

Tempfiles are "sparsely populated files" (not certain if that is the correct term). That is, if you display them with the command "ls -l", you'll see them apparently consuming the full amount of space you specified when you created them. However, if you get the chance, try to perform a "df -k" against the file-system in question before and after you ADD TEMPFILE and you'll see that the space consumed within the file-system doesn't change. Then, as sorting or global-temporary-table activity hits the TEMP tablespace, you'll see changes in "df -k"...

In essence, there is a difference between the output displayed by "ls -l" and "df -k", and the "df" command is correct. I'm not sure how the "du" command reacts to all this...

Not really sure how to explain it, but I'm pretty that this is what you are experiencing. Rather annoying, isn't it?

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, October 10, 2002 9:13 AM

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tim Gorman
  INET: Tim_at_SageLogix.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).