Oracle Database – total size of the database

Oracle Database – consists of data files, redo log files, control files, temporary files and the size of the database actually means the total size of all these files

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

This entry was posted on Dienstag, Januar 1st, 2019 at 00:59 and is filed under Administration, Healthcare Info, ORACLE Database. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply

You must be logged in to post a comment.