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;
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;