統計Oracle資料庫檔案的大小，統計oracle資料庫

統計Oracle資料庫檔案的大小，統計oracle資料庫
1. 統計資料檔案、臨時檔案、記錄檔大小

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. 統計Oracle資料庫檔案佔用空間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)

本文地址：http://blog.csdn.net/sunansheng/article/details/46325139