Re: How Big is My database?

SatarNag wrote:
>
> I am tryinr to figuire how much space does my Oracle 7.3 Database take up
> on my server. I am new to Oracle and I was wonderring if there was a View
> that displays that information. Please Help....My e-mail is
> SatarNag_at_aol.com
>
> I thank you in advance for any responses,
> Satar Naghshineh

Try this. It returns the number of megabytes taken up by your datafiles and online redo log files.

select sum(bytes) / (1024*1024)
from ( select bytes from dba_data_files union all

       select bytes*members from v$log);

You will then need to add in the size of your controlfiles, which are generally very small.

-- 
Bob Swisshelm
Eli Lilly and Company
swisshelm_at_lilly.com