file size on disk vs used drastically different

[Craig White]

On Thu, 2010-04-15 at 10:18 -0700, Shawn Badger wrote:
> I came across a weird problem this morning. What would cause a file to
> be reported as 251M for used space and 1.3G for size on disk?
> 
> [root at cc1lnx5 axprac]# ls -sh cafrap_1.dbf; ls -lh cafrap_1.dbf
> 251M cafrap_1.dbf
> -rw-r----- 1 oraxprac axprac 1.3G Apr 15 09:47 cafrap_1.dbf
> [root at cc1lnx5 axprac]# 
> 
> 
> I have seen this to a smaller extent with some files but never a
> variance of this size.
> This file happens to be an Oracle 11G database table file.
----
I would tend to expect any database files to vary in size based upon
usage and most of them have external utilities available to
compact/vacuum/clean (terminology varies from one db to another) but
essentially to remove old rows and reduce file size.

Craig


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.