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;......
admin