2020년 1월 2일 IT - Oracle Table Space 조회
-- TableSpace 확인 쿼리 SELECT "Check Time" ,TS_INFO.tablespace_name ,TS_INFO."MAX SIZE(MB)" ,TS_INFO."USED(MB)" ,TS_INFO."USED %" ,TS_INFO."STATUS" FROM ( SELECT SYSDATE "Check Time" ,tablespace_name ,TO_CHAR(round((total_size/1024),4),'999,990.999') "MAX SIZE(MB)" ,TO_CHAR(round((used/1024),4),'999,990.999') "USED(MB)" ,TO_CHAR((total_size/1024)-(round((used/1024),4)),'999,990.999') "AVAIL(MB)" ,T..
IT
2020. 1. 2. 09:11
