SELECT D.TABLESPACE_NAME,SPACE,BLOCKS SUM_BLOCKS,SPACE-NVL(FREE_SPACE,0),
ROUND((1-NVL(FREE_SPACE,0)/SPACE)*100,2),FREE_SPACE FROM
(SELECT TABLESPACE_NAME,ROUND(SUM(BYTES)/(1024*1024),2) SPACE,SUM(BLOCKS) BLOCKS FROM DBA_DATA_FILES
GROUP BY TABLESPACE_NAME) D,
(SELECT TABLESPACE_NAME,ROUND(SUM(BYTES)/(1024*1024),2) FREE_SPACE FROM DBA_FREE_SPACE
GROUP BY TABLESPACE_NAME) F WHERE D.TABLESPACE_NAME = F.TABLESPACE_NAME(+)
and D.TABLESPACE_NAME IN('SYSTEM');
Oracle查询表空间使用大小,使用率,剩余大小,百分比
最新推荐文章于 2024-04-18 05:32:12 发布