oracle表空間查詢sql

--TABLESPACE_NAME 表空間名稱,total 存儲總量,used 已用空間,free 未用空間
SELECT A.TABLESPACE_NAME,
       A.BYTES/(1024*1024) TOTAL,
       B.BYTES/(1024*1024) USED,
       C.BYTES/(1024*1024) FREE,
       round((B.BYTES * 100) / A.BYTES) "% USED",
       round((C.BYTES * 100) / A.BYTES) "% FREE"
  FROM SYS.SM$TS_AVAIL A, SYS.SM$TS_USED B, SYS.SM$TS_FREE C
 WHERE A.TABLESPACE_NAME = B.TABLESPACE_NAME
   AND A.TABLESPACE_NAME = C.TABLESPACE_NAME;