查询语句如下
SELECT NVL(B.TABLESPACE_NAME, NVL(A.TABLESPACE_NAME, 'UNKOWN')) NAME,
KBYTES_ALLOC KBYTES,
KBYTES_ALLOC - NVL(KBYTES_FREE, 0) USED,
NVL(KBYTES_FREE, 0) FREE
((KBYTES_ALLOC - NVL(KBYTES_FREE, 0)) / KBYTES_ALLOC) * 100 PCT_USED,
NVL(LARGEST, 0) LARGEST
FROM (SELECT SUM(BYTES) / 1024 KBYTES_FREE,
MAX(BYTES) / 1024 LARGEST,
TABLESPACE_NAME
FROM SYS.DBA_FREE_SPACE
GROUP BY TABLESPACE_NAME) A,
(SELECT SUM(BYTES) / 1024 KBYTES_ALLOC,
TABLESPACE_NAME
FROM SYS.DBA_DATA_FILES
GROUP BY TABLESPACE_NAME) B
WHERE A.TABLESPACE_NAME(+) = B.TABLESPACE_NAME
ORDER BY PCT_USED DESC
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24389441/viewspace-1056691/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/24389441/viewspace-1056691/