查看ORACLE各表空间使用情况
Sql代码
–各表空间分配情况
select tablespace_name, sum(bytes) / 1024 / 1024
from dba_data_files
group by tablespace_name;
&nbsoracle账号p;
–各表空间空闲情况
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;
作者 guooo