SELECT A.TABLESPACE_NAME,
A.CURR_MB,
ROUND((A.CURR_MB - B.FREE_MB)) USED_MB,
ROUND((B.FREE_MB / A.CURR_MB) * 100, 2) || '%' FREE_PCT,
A.MAX_MB
FROM (SELECT TABLESPACE_NAME,
SUM(BYTES) / 1048576 CURR_MB,
ROUND(SUM(MAXBYTES) / 1048576, 2) MAX_MB
FROM DBA_DATA_FILES
GROUP BY TABLESPACE_NAME) A,
(SELECT TABLESPACE_NAME, SUM(BYTES) / 1048576 FREE_MB
FROM DBA_FREE_SPACE
GROUP BY TABLESPACE_NAME) B
WHERE A.TABLESPACE_NAME = B.TABLESPACE_NAME;
A.CURR_MB,
ROUND((A.CURR_MB - B.FREE_MB)) USED_MB,
ROUND((B.FREE_MB / A.CURR_MB) * 100, 2) || '%' FREE_PCT,
A.MAX_MB
FROM (SELECT TABLESPACE_NAME,
SUM(BYTES) / 1048576 CURR_MB,
ROUND(SUM(MAXBYTES) / 1048576, 2) MAX_MB
FROM DBA_DATA_FILES
GROUP BY TABLESPACE_NAME) A,
(SELECT TABLESPACE_NAME, SUM(BYTES) / 1048576 FREE_MB
FROM DBA_FREE_SPACE
GROUP BY TABLESPACE_NAME) B
WHERE A.TABLESPACE_NAME = B.TABLESPACE_NAME;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/27500440/viewspace-1130209/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
查询系统关键信息
下一篇：
Oracle用户角色权限管理
请登录后发表评论
登录
全部评论
