Re: file size on disk vs used drastically different

Top Page
Attachments:
Message as email
+ (text/plain)
+ (text/html)
+ (text/plain)
Delete this message
Reply to this message
Author: Shawn Badger
Date:  
To: Main PLUG discussion list
Subject: Re: file size on disk vs used drastically different
I am having the DBA run some tools to try and clean it up. I have just never
seen a file with that big of a difference and wanted to see if anyone knows
what caused it to occur.



On Thu, Apr 15, 2010 at 10:30 AM, Craig White <>wrote:

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

---------------------------------------------------
PLUG-discuss mailing list -
To subscribe, unsubscribe, or to change your mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss