Allen 2020-05-25 09:13:15 34209 0 0 0 0

---

SELECT D.TABLESPACE_NAME,SPACE "SUM_SPACE(M)",BLOCKS SUM_BLOCKS,SPACE-NVL(FREE_SPACE,0) "USED_SPACE(M)",  
       ROUND((1-NVL(FREE_SPACE,0)/SPACE)*100,2) "USED_RATE(%)",FREE_SPACE "FREE_SPACE(M)"  
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(+)  
  UNION ALL --if have tempfile  
  SELECT D.TABLESPACE_NAME,SPACE "SUM_SPACE(M)",BLOCKS SUM_BLOCKS, 
       USED_SPACE "USED_SPACE(M)",ROUND(NVL(USED_SPACE,0)/SPACE*100,2) "USED_RATE(%)",  
       NVL(FREE_SPACE,0) "FREE_SPACE(M)"  
  FROM  
  (SELECT TABLESPACE_NAME,ROUND(SUM(BYTES)/(1024*1024),2) SPACE,SUM(BLOCKS) BLOCKS  
  FROM DBA_TEMP_FILES  
  GROUP BY TABLESPACE_NAME) D,  
  (SELECT TABLESPACE_NAME,ROUND(SUM(BYTES_USED)/(1024*1024),2) USED_SPACE, 
        ROUND(SUM(BYTES_FREE)/(1024*1024),2) FREE_SPACE  
  FROM V$TEMP_SPACE_HEADER  
  GROUP BY TABLESPACE_NAME) F  
WHERE D.TABLESPACE_NAME = F.TABLESPACE_NAME(+) 

【版權聲明】
本文爲原創，遵循CC 4.0 BY-SA版權協議！轉載時請附上原文鏈接及本聲明。
原文鏈接：https://tdlib.com/am.php?t=6CIZCwASCee9 Tag: Oracle维护 OracleSql

評論

相關內容

歡迎評論