Statistics on the size of Oracle Database files, statistics on oracle databases

Statistics on the size of Oracle Database files, statistics on oracle databases
1. Statistics file, temporary file, Log File Size

Select sum (bytes)/1024/1024/1024 as GB from dba_data_files; select sum (bytes)/1024/1024/1024 as GB from dba_temp_files; select sum (bytes) /1024/1024/1024 as GB from v $ log;

2. Count the space occupied by the Oracle database files. Total Size of the database = A + B + C

Select sum (gb) total_gb from (select sum (bytes)/1024/1024/1024 as gb from dba_data_files union all select sum (bytes) /1024/1024/1024 as gb from dba_temp_files union all select sum (bytes)/1024/1024/1024 as gb from v $ log)

Address: http://blog.csdn.net/sunansheng/article/details/46325139