查看表空间文件的大小:
select tablespace_name,bytes/1024/1024||‘M’ from dba_data_files;
查看表空间空余空间大小:
select tablespace_name,sum(bytes)/1024/1024||'M' from dba_free_space group by tablespace_name;
查看表空间文件的大小:
select tablespace_name,bytes/1024/1024||‘M’ from dba_data_files;
查看表空间空余空间大小:
select tablespace_name,sum(bytes)/1024/1024||'M' from dba_free_space group by tablespace_name;