[DB] 테이블스페이스 용량 조회
SELECT (SELECT TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:MM') FROM DUAL) SYSDT, SUBSTR(A.TABLESPACE_NAME,1,30) TABLESPACE, ROUND(SUM(A.TOTAL1)/1024/1024,1) "TOTALMB", ROUND(SUM(A.TOTAL1)/1024/1024,1)-ROUND(SUM(A.SUM1)/1024/1024,1) "USEDMB", ROUND(SUM(A.SUM1)/1024/1024,1) "FREEMB", ROUND((ROUND(SUM(A.TOTAL1)/1024/1024,1)-ROUND(SUM(A.SUM1)/1024/1024,1))/ROUND(SUM(A.TOTAL1)/1024/1024,1)*100,2) "USED%" FROM (..
2020. 9. 16.