Reenu

• Jan 25th, 2007

 

You have add bytes in these 2 views DBA_FREE_SPACE (free space in db) DBA_segments(used space in db)

ram

• Mar 6th, 2007

 

select sum(bytes/1024/1024/1024) from dba_data_files

prati

• Mar 7th, 2007

 

select sum ( bytes) from dba_data_files ;
select sum(bytes) from v$log;
select sum ( bytes ) from dba_temp_files ;
Total sum of all the three will give the database size .

sanu

• Sep 26th, 2012

 

SQL> select a.datafile_size + b.temp_size + c.redo_size + d.controlfile_size "Total_size in GB"
from ( select sum(bytes)/1024/1024/1024 as datafile_size
from dba_data_files) a,
( select nvl(sum(bytes),0)/1024/1024/1024 as temp_size
from dba_temp_files ) b,
( select sum(bytes)/1024/1024/1024 as redo_size
from sys.v_$log ) c,
( select sum(BLOCK_SIZE*FILE_SIZE_BLKS)/1024/1024/1024 as controlfile_size
from v$controlfile) d ;
output :

Nadeem

• Feb 12th, 2015

 

Select sum(bytes)/1024/1024/1024 AS sizeGB from dba_data_files;

nunesrinivas

• Mar 25th, 2015

 

Select sum