Re: How Big is My database?

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




Thank You Bob Swisshelm, the information was useful.
Satar Naghshineh