 SELECT t1 "表空間",z "總表空間",z-s "已用表空間",s "剩餘表空間",ROUND((z-s)/z*100,2) "使用率%"
     From (Select tablespace_name t1,Sum(bytes) s
              From DBA_FREE_SPACE Group by tablespace_name),
           (Select tablespace_name t2,Sum(bytes) z
           From DBA_DATA_FILES Group by tablespace_name) Where t1=t2;

怎麼檢視oracle表空間，剩餘大小，表空間利用

相關文章