Oracle查看表空间大小

 查看存储剩余大小
SQL> select name,free_mb,total_mb from v$asm_diskgroup;

SELECT A.TABLESPACE_NAME,A.BYTES TOTAL,B.BYTES USED, C.BYTES FREE,
    (B.BYTES*100)/A.BYTES "% USED",(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
    order by A.TABLESPACE_NAME;

SELECT Total.name "Tablespace Name",
       Free_space,
       (total_space - Free_space) Used_space,
       total_space
  FROM (select tablespace_name, sum(bytes / 1024 / 1024/1024) Free_Space
          from sys.dba_free_space
         group by tablespace_name) Free,
       (select b.name, sum(bytes / 1024 / 1024/1024) TOTAL_SPACE
          from sys.v_$datafile a, sys.v_$tablespace B
         where a.ts# = b.ts#
         group by b.name) Total
 WHERE Free.Tablespace_name = Total.name;

select a.tablespace_name,
       round(a.bytes/(1024*1024),1) total,
       round(b.bytes/(1024*1024),1) used,
       round(c.bytes/(1024*1024),1) free,
       round((b.bytes*100)/a.bytes,1) "%used",
       round((c.bytes*100)/a.bytes,1) "%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 order by 5 desc;