----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@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@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.
---------------------------------------------------
PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
To subscribe, unsubscribe, or to change your mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss