Re: actual space used.

From: Wesley Joyce (Wesley.Joyce@UVI.EDU)
Date: Fri Sep 27 2002 - 13:40:51 EDT


I have posed a related question in the past. While browsing
www.aixgeek.org, I found this excerpt

Question: The "df" and "du" commands indicate that the file system is 50%
full, but you notice that the total size of all files, as given by "ls" is
greater than the size of the file system. How is this possible?
Answer: These are sparse files, where the size of the file is larger than
the amount of space it takes up. The file contains a large of "null blocks".

If I remember correctly, Oracle reserves space in it's table spaces which
make the data files. Those reservation might be what is called "null
blocks". Wouldn't this help explain why the output of the df command and
ls is different? Obviously this isn't a solution but it helps me to
understand a little better. Maybe we should take this to an Oracle list?

At 05:23 PM 9/24/2002, Barnhart, Troy wrote:

>does anyone out there have a script or such that can tell how
>much space you system has?
>
>such as something that can take the data from a "df -k" plus
>the space occupied by the raw datafiles that oracle uses
>
>tia,
>troy
>
>Troy Barnhart, Sr. Systems Programmer,
>tbarnhart@rcrh.org
>Rapid City Regional Hospital,
>Rapid City, South Dakota, 57701
>ph: 605-719-8068 / fax: 605-719-4206
>
>
>
>
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.391 / Virus Database: 222 - Release Date: 9/19/2002

Wesley Joyce, Systems Administrator
Center for Administrative Computing (CAC), IT
University of the Virgin Islands
#2 John Brewers Bay, St. Thomas, USVI 00802-9990
(340) 693-1469 (voice) / (340) 693-1465 (fax)
http://www.uvi.edu

"If you can't explain it simply, than you don't know it well enough. -
Unknown."


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.391 / Virus Database: 222 - Release Date: 9/19/2002


This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 22:16:13 EDT