Re: Why is my database so huge?

From: Chris Markle <chris.markle_at_level3.com>
Date: Tue, 08 Jun 1999 15:54:57 -0600
Message-ID: <375D9131.FCAE2A94@level3.com>

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

Check the default storage settings for the tablespace, if they are set very high (i.e. initial 10m, etc) then
each table in the import (assuming the source tables did not have specific storage parameters set)
will be allocated using the defaults for the tablespace. Received on Tue Jun 08 1999 - 16:54:57 CDT