Re: Why is my database so huge?

From: Brian Gallagher <briang_at_iona.com>
Date: Fri, 4 Jun 1999 16:34:00 +0100
Message-ID: <7j8rt4$ous$1@bvweb.dublin.iona.ie>

oracle pre-allocates space so your tablespace had 284 MB pre-allocated before your import.

select * from dba_free_space;

as dba will show you all your free space

regards
brian

Jeremy Bettis wrote in message ...
>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 Fri Jun 04 1999 - 10:34:00 CDT