Total size of Database

Total size of Database

An oracle database consists of data files, redo log files, control files, temporary files. 
The size of the database actually means the total size of all these files.


SQL> select ( select sum(bytes)/1024/1024/1024 data_size from dba_data_files ) + ( select nvl(sum(bytes),0)/1024/1024/1024 temp_size from dba_temp_files ) + ( select sum(bytes)/1024/1024/1024 redo_size from sys.v_$log ) + ( select sum(BLOCK_SIZE*FILE_SIZE_BLKS)/1024/1024/1024 controlfile_size from v$controlfile) "Size in GB" from dual

OUTPUT
-----------------------------------------
Size in GB
615.947875976563
---------------------------------------