1。查看所有表空间大小:
Sql代码
select tablespace_name,sum(bytes)/1024/1024 from dba_data_files group by tablespace_name;
2。已经利用的表空间大小:
Sql代码
select tablespace_name,sum(bytes)/1024/1024 from dba_free_space group by tablespace_name;
3。
所以利用空间能够如许计算:
Sql代码
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;。
0