标题: 查看ORACLE各表空间使用情况 [打印本页] 作者: 陈晓龙 时间: 2020-7-6 23:36 标题: 查看ORACLE各表空间使用情况 Sql代码
--各表空间分配情况
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 -www.2cto.com-
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;