file size on disk vs used drastically different

[Shawn Badger]

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 <craigwhite at azapple.com>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 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.
>
> ---------------------------------------------------
> PLUG-discuss mailing list - PLUG-discuss at lists.plug.phoenix.az.us
> To subscribe, unsubscribe, or to change your mail settings:
> http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.PLUG.phoenix.az.us/pipermail/plug-discuss/attachments/20100415/120403df/attachment.htm>