Oracle database consist of datafiles,redo log files, control files and temp files.
And sum of all these file is the size of the oracle database.
i.e
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;
========================================================================
Do you like this post? Please share this article.
HTML Link Code:
Post a Comment