查看ORACLE各表空间使用情况

 

--各表空间分配情况 
select tablespace_name, sum(bytes) / 1024 / 1024
  from dba_data_files
 group by tablespace_name;

--各表空间空闲情况
select tablespace_name, sum(bytes) / 1024 / 1024
  from dba_free_space
 group by tablespace_name;

--列表查看各表空间情况
select a.tablespace_name, total, free, total - free used
  from (select tablespace_name, sum(bytes) / 1024 / 1024 total
          from dba_data_files
         group by tablespace_name) a,
       (select tablespace_name, sum(bytes) / 1024 / 1024 free
          from dba_free_space
         group by tablespace_name) b
 where a.tablespace_name = b.tablespace_name;

 

手机扫一扫，欢迎关注公众号

关注程序员成长