Re: Why is my database so huge?

From: Thirumurugan vadivelu <tvadivelu_at_infonautics.com>
Date: Thu, 03 Jun 1999 17:53:17 -0400
Message-ID: <3756F94D.E817395E@infonautics.com>

I am not sure if you are looking into the Correct Views to find out the Occupied and Free Space.
Try the following views :

DBA_FREE_SPACE
DBA_SEGMENTS
DBA_EXTENTS

Did U precreate the Tables before Importing the DATA ? If you had created extents with much higher value than required ,than there is every chance that the Table might be 100s of Meg even if the actual Space Used might be < 10 M. Try ALTER TABLE ..DEALLOCATE UNUSED ;
if this is the Case.

All the Best !

-Thiru

Jeremy Bettis wrote:

> I have a empty database, that I imported a 6MB export file into. The
> tablespace containing all the tables in the export file is now 284MB!
>
> I understand that there is some overhead, indices, free space, etc. But 6 to
> 284???
>
> Where is this space?
>
> does "select avg_space*blocks from all_tables" tell me how much empty space
> there is in my tables?
> --
> Jeremy Bettis
> jeremy_at_hksys.com
Received on Thu Jun 03 1999 - 16:53:17 CDT