ORACLE表空间管理维护

查看表空间 ：

 

SELECT A.TABLESPACE_NAME                     AS TABLESPACE_NAME, 
         ROUND(A.BYTES/(1024*1024*1024),2)    AS "TOTAL(G)"     , 
          ROUND(B.BYTES/(1024*1024*1024),2)    AS "USED(G)"      , 
          ROUND(C.BYTES/(1024*1024*1024),2)    AS "FREE(G)"      , 
          ROUND((B.BYTES * 100) / A.BYTES,2)   AS "% USED"       , 
          ROUND((C.BYTES * 100) / A.BYTES,2)   AS "% 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;

 

抄袭路径 ： http://www.cnblogs.com/kerrycode/p/3418694.html