Oracle查看数据库中文件的总大小-CSDN博客

网站介绍:文章浏览阅读1.3w次,点赞6次,收藏27次。保留两位小数以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;...