oracle数据量统计

1.数据文件总大小

SELECT ROUND(SUM(BYTES)/1024/1024/1024,2)||'GB' FROM DBA_DATA_FILES;

SELECT TABLESPACE_NAME,SUM(BYTES)/1024/1024 AS MB FROM DBA_DATA_FILES GROUP BY TABLESPACE_NAME;

2.临时文件大小

SELECT SUM(BYTES)/1024/1024/1024 AS GB FROM DBA_TEMP_FILES;

3.日志文件大小

SELECT SUM(BYTES)/1024/1024/1024 AS GB FROM V$LOG;

4.数据文件临时文件日志文件总大小

SELECT SUM(GB) AS GB

FROM(

SELECT SUM(BYTES)/1024/1024/1024 AS GB

FROM DBA_DATA_FILES

UNION ALL

SELECT SUM(BYTES)/1024/1024/1024

FROM DBA_TEMP_FILES

UNION ALL

SELECT SUM(BYTES)/1024/1024/1024

FROM V$LOG

);