Re: SQL Script/Tools to determine db size

Display sum free space:

select tablespace_name, trunc(sum( bytes/(1024*1024)),2 ) MB_free from dba_free_space group by tablespace_name;

Used space (in MB)
select distinct e.file_id, f.file_name, trunc(sum(e.bytes)/(1024*1024),2)MB_Used

  from dba_extents e, dba_data_files f
  where e.file_id=f.file_id
  group by e.file_id, f.file_name;

James Bone wrote:

> Hi,
>
> I have an Oracle 7.0 db running on a Unix machine and I need to try and
> figure out how much disk space is being used up. The database is sitting on
> a raw partition. Does anyone have any sql scripts or tools to determine the
> actual percent of space the db is taking up?
>
> Any help would really be appreciated.
>
> Jim

--
-------------------------------------
ADICOM Informatik GmbH
Andreas Michler
Wiesfleckenstr. 34
72336 Balingen
Tel: 07433/9977-57,Fax: -90
E-Mail: Andreas.Michler_at_adicom.de
http:\\www.adicom.de
-------------------------------------