查看表空间使用情况

select fs.tablespace_name tablespace,
       (df.totalspace - fs.freespace) used_mb,
       fs.freespace free_mb,
       df.totalspace total_mb,
       round(100 * (fs.freespace / df.totalspace)) pct_free
  from (select tablespace_name, round(sum(bytes) / 1024 / 1024) totalspace
          from dba_data_files
         group by tablespace_name) df,
       (select tablespace_name, round(sum(bytes) / 1024 / 1024) freespace
          from dba_free_space
         group by tablespace_name) fs
 where df.tablespace_name = fs.tablespace_name
   and fs.tablespace_name = 'APPLSYSD';

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10359218/viewspace-678550/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10359218/viewspace-678550/