保留两位小数以GB为单位显示数据文件大小:
SELECT ROUND(SUM(BYTES)/1024/1024/1024,2)||'GB'
FROM DBA_DATA_FILES;
以MB为单位表空间分组显示数据文件大小:
SELECT TABLESPACE_NAME,SUM(BYTES)/1024/1024 AS MB
FROM DBA_DATA_FILES
GROUP BY TABLESPACE_NAME;
显示数据库中临时文件的大小:
SELECT SUM(BYTES)/1024/1024/1024 AS GB
FROM DBA_TEMP_FILES;
显示数据库中日志文件的大小:
SELECT SUM(BYTES)/1024/1024/1024 AS GB
FROM V$LOG;
显示数据库中数据文件、临时文件、日志文件的总大小:
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
);